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...
2016-04-03
694 reads
It has been a while since I blogged. Just moved to few other mediums like speaking at user group and...
2016-04-03
694 reads
Most of us are aware of Statistics in SQL Server and its purpose. But still, just to get started, statistics...
2016-01-25 (first published: 2016-01-13)
3,201 reads
Checkpoint processes and other internal processes have undergone major changes for In Memory OLTP tables and transactions. The following article...
2015-11-18
683 reads
Finding a row count in a "in memory" Hekaton table can be a tricky task as the regular commands and...
2015-11-06
936 reads
Hash Indexes on "In memory" tables are best suited for equality searches. Reason is obvious, as they are based on...
2015-11-02
485 reads
Last few posts have explored hash indexes in depth. This one will deal with the limitations on Hash Indexes. What...
2015-10-25
399 reads
Continuing from previous post , this post will discuss a few scenarios on hash collisions.
The following "in memory" table with a hash...
2015-10-11
588 reads
As explained in the earlier post, a hash index places pointers to the rows in hash buckets, depending upon the value returned...
2015-09-15
689 reads
With SQL Server 2014, new type of Index called the hash index was introduced. Little introduction to hash function would...
2015-09-11 (first published: 2015-09-08)
2,585 reads
After a short little break on Hekaton series, we are now back with the 5th post.
Two new index types...
2015-09-04
720 reads
Welcome back, my fellow sleuths, to my mystery-inspired blog series! I’m having a ton...
By Steve Jones
This was one of the original values: The facing page has this text: No...
By Chris Yates
For decades, enterprises have thought about data like plumbers think about water: you build...
Comments posted to this topic are about the item Create an HTML Report on...
Comments posted to this topic are about the item Database Ledger in SQL Server...
Comments posted to this topic are about the item Azure SQL Database MAXDOP
When Azure SQL Database was originally released, the MAXDOP was set to 0 for each new database. In Oct 2025, what is the default value for Azure SQL databases?
See possible answers