How to get Page ID for row(s) in a table in SQL Server

There can be situations like in my previous post Attempt to fetch logical page # in database failed when you need to know to which page be...

Read More

Hekaton Part 6:- Hash Indexes - Intro

With SQL Server 2014, new type of Index called the hash index was introduced. Little introduction to hash function would help understanding...

Read More

Hekaton Part 7 - Hash Collisions & Hash Buckets

As explained in the earlier post , a hash index places pointers to the rows in hash buckets, depending upon the value returned by hash func...

Read More

Hekaton Part 8 - Hash Collisions - Hash_Index_Stats DMV

Continuing from previous  post , this post will discuss a few scenarios on hash collisions.   The following "in memory" tabl...

Read More

Hekaton Part 9: Things Hash Indexes can't do

Last few posts have explored hash indexes in depth. This one will deal with the limitations on Hash Indexes. What are things hash indexes c...

Read More

In-Memory OLTP Table Checkpoint Processes Performance Comparison

Checkpoint processes and other internal processes have undergone major changes for In Memory OLTP tables and transactions. The following ar...

Read More

SQL Server Statistics - Histograms

Most of us are aware of Statistics in SQL Server and its purpose. But still, just to get started, statistics store information on the distr...

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

Cardinality Estimator - Part 2- Out of Date Statistics

Continuing from our series on Cardinality Estimator 2014, Let us look at the first difference between 2 CE models. The way estimates are ma...

Read More