When do Distribution Statistics Get Updated?
Statistics objects are important to us for allowing SQL to make good estimates of the row-counts involved in different parts...
2017-07-05
776 reads
Matthew McGiffen DBA
Row-count Estimates when there are no Statistics
I was discussing Cardinality Estimation with a colleague recently and the question came up, what cardinality does SQL Server use...
2017-07-12 (first published: 2017-06-28)
2,879 reads
Statistics and Cardinality Estimation
Cardinality
This is a term originally from Mathematics, generally defined as “The number of objects in a given set or grouping”....
2017-06-30 (first published: 2017-06-20)
5,834 reads
What’s an “Index” and how do they work?
What is an Index?
We often hear indexes explained using the analogy of an index in the back of a book....
2017-06-12
1,593 reads
SQL Puzzle 1: Magic Squares
This is the first in what I hope will be a semi-regular series of recreational puzzles where SQL can be...
2017-06-07
1,609 reads
Working with Data in Always Encrypted
In this post we’re going to create some encrypted columns in a table in a test database and look at...
2017-06-06
10,915 reads
Statistics Parser
In the last post we looked at using the STATISTICS IO and STATISTICS TIME commands to measure query performance.
If you’ve...
2017-06-14 (first published: 2017-05-31)
2,470 reads
Understanding Keys and Certificates with Always Encrypted
Always Encrypted on SQL 2016 is pretty easy to set up. There’s even a single wizard to guide you through...
2017-06-09 (first published: 2017-05-30)
8,597 reads
Tuning Parallelism on SQL Server
Parallelism and MAXDOP
There’s no doubt that parallelism in SQL is a great thing. It enables large queries to share the...
2017-05-26
5,311 reads
Measuring SQL Query Performance
When running workshops on the subject of SQL Query Performance the first question I always ask is how do we measure...
2017-06-08 (first published: 2017-05-24)
37,374 reads
Blogs
Microsoft MVP 2026: Ten Years on the Data Platform
I’m honored to announce that I’ve been renewed as a Microsoft MVP for the...
Building AgentDBA’s Slack Escalation
By Arun Sirpal
Until now, a CRITICAL finding did the right internal routing, but the last mile...
Changing the Owner Removes Permissions: #SQLNewBlogger
By Steve Jones
This is actually inspired by an article SQL Server Central, which taught me something...
Forums
Developer edition cannot connect from other computers
I installed a new SQL server 2025 Enterprise developer edition for our development environment....
How Clustering can be Used as a Preprocessing Technique for Classification in Azure Machine Learning
Comments posted to this topic are about the item How Clustering can be Used...
Moving the Error Log
Comments posted to this topic are about the item Moving the Error Log
Question of the Day
Moving the Error Log
How can I change the location in which the SQL Server error log is written in SQL Server 2025?
See possible answers