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
784 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,882 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,854 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,597 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,632 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
11,028 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,527 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,642 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,320 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,627 reads
Blogs
Monday Monitor Tips: Configuring Access to the MCP Server
By Steve Jones
I have been experimenting with MCP servers in a few ways, including the Redgate...
The GO Barrier: Why SSMS Multi-Server Query Waits for the Slowest Connection
By Zikato
I deployed a schema change to 30 servers using multi-server query and deploy-at-low-priority. Small...
10 Things I Hate About Fabric Deployment Pipelines— And Some Alternatives
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
Forums
A Challenge of Our Knowledge
Comments posted to this topic are about the item A Challenge of Our Knowledge
The memory toll of VARCHAR(MAX) in SQL Server
Comments posted to this topic are about the item The memory toll of VARCHAR(MAX)...
Transaction Log Truncation
Comments posted to this topic are about the item Transaction Log Truncation
Question of the Day
Transaction Log Truncation
In SQL Server 2025, where can I find information about items that prevent or delay the transaction log truncation?
See possible answers