Group by query hash to add up every cached copy of one query. See why the top query hides across entries in SQL Server.
Same Query Plan, Different Cache Entry in SQL Server
The same query plan can sit in the cache many times when query text changes by a space, a letter case or a comment. See it, measure it and learn how to share one entry.
Best Value for Maximum Worker Threads – SQL in Sixty Seconds #170
A very common question I often receive during Comprehensive Database Performance Health Check is what is the best value for Maximum Worker Threads.
SQL SERVER – Display Dates in Different cultures FORMAT
Today we are going to learn a very simple and interesting concept used very little. It is about how to Display Dates in Different cultures FORMAT.
Rowstore to Columnstore: Replace the Clustered Index
Rowstore to columnstore is a change of the clustered index, and one command works in only one case. This post builds two tables of 600,000 rows, shows the error from DROP_EXISTING on a primary key, and converts each table the working way. It compares the sizes before and after.
Read-Ahead Reads in STATISTICS IO: What They Tell You
Interpret read-ahead reads in STATISTICS IO, compare isolated cold scans and seeks, and separate prefetch from storage-wait evidence.
EDIT_DISTANCE and JARO_WINKLER: Fuzzy String Matching in SQL Server 2025
EDIT_DISTANCE counts the single-character changes between two strings, and the JARO_WINKLER functions score how alike they look. This post tests the four preview functions on SQL Server 2025, shows the Windows collation error and its fix, and finds near-duplicate customer names.