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
697 reads
SQL and SQL Only
SQL Server Statistics - Histograms
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,204 reads
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 article...
2015-11-18
685 reads
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...
2015-11-06
937 reads
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...
2015-11-02
487 reads
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...
2015-10-25
400 reads
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" table with a hash...
2015-10-11
592 reads
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...
2015-09-15
693 reads
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...
2015-09-11 (first published: 2015-09-08)
2,590 reads
Hekaton Part 5: Introduction to Indexes in "In Memory Tables"
After a short little break on Hekaton series, we are now back with the 5th post.
Two new index types...
2015-09-04
722 reads
Blogs
Don’t Miss Out – SQL Server Query Tuning Fundamentals Starts Next Monday!
Next Monday, February 9, 2026, my one-day live online training SQL Server Query Tuning...
Monday Monitor Tips: SQL Auditing Preview
By Steve Jones
One of the features we advocates have been advocating for is a better way...
SQL Server 2025 CU1 Fixes the Docker Desktop AVX Issue on macOS
Microsoft fixed the AVX instruction issue in SQL Server 2025 CU1. The container now...
Forums
25 Years of SQL Server Central
Comments posted to this topic are about the item 25 Years of SQL Server...
The Decoded Value
Comments posted to this topic are about the item The Decoded Value
Deploying SQL Server Developer Edition in Kubernetes: A Cost-Effective Alternative to RDS
Comments posted to this topic are about the item Deploying SQL Server Developer Edition...
Question of the Day
The Decoded Value
In SQL Server 2025, what is returned from this code:
DECLARE @message VARCHAR(50) = 'Hello SQL Server 2025!'; DECLARE @encoded VARCHAR(MAX); SET @encoded = BASE64_ENCODE(CAST(@message AS VARBINARY(1000))); SELECT BASE64_DECODE(@encoded)See possible answers