Inserting UniCode / Special characters in tables

Consider the situation where one needs to store multilingual data / Special characters into a table. For example Chinese characters or Tamil...

Read More

Calling Function / UDF using linked server

If one needs to call a UDF or System function ( ex: Serverproperty, Getdate(), etc ) on a remote server, then one cannot use the usual 4 par...

Read More

Hekaton Part 10: Things Hash Indexes Can do

Hash Indexes on "In memory" tables are best suited for equality searches. Reason is obvious, as they are based on hash algorithm ...

Read More

Hekaton Part 11 :- Finding row count in memory table

Finding a row count in a "in memory" Hekaton table can be a tricky task as the regular commands and DMVs don't give the desir...

Read More

SQL Server 2014 - Cardinality Estimator - Part 1

It has been a while since I blogged. Just moved to few other mediums like speaking at user group and SQL Saturday events in the last few mo...

Read More

Sp_recompile doesn't recompile!!!!

Many of us use the stored procedure " sp_recompile " to mark the stored procedure for recompilation, so that next time it runs we...

Read More

Query Plan's Compile Time Parameter Values

Most of you would know how to get the query plan from the cache via " sys.dm_exec_cached_plans " or " sys.dm_exec_query_st...

Read More