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
751 reads
Statistics objects are important to us for allowing SQL to make good estimates of the row-counts involved in different parts...
2017-07-05
751 reads
I was discussing Cardinality Estimation with a colleague recently and the question came up, what cardinality does SQL Server use...
2019-04-26 (first published: 2017-06-28)
2,722 reads
Cardinality
This is a term originally from Mathematics, generally defined as “The number of objects in a given set or grouping”....
2019-04-26 (first published: 2017-06-20)
5,625 reads
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,554 reads
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,483 reads
In this post we’re going to create some encrypted columns in a table in a test database and look at...
2017-06-06
8,266 reads
In the last post we looked at using the STATISTICS IO and STATISTICS TIME commands to measure query performance.
If you’ve...
2019-04-26 (first published: 2017-05-31)
1,933 reads
Always Encrypted on SQL 2016 is pretty easy to set up. There’s even a single wizard to guide you through...
2019-04-26 (first published: 2017-05-30)
7,234 reads
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,139 reads
When running workshops on the subject of SQL Query Performance the first question I always ask is how do we measure...
2019-04-26 (first published: 2017-05-24)
29,739 reads
In the realm of data science, SQL (Structured Query Language) reigns supreme. It's your...
By Brian Kelley
The bottom line here is this: the idea that a CSP takes care of...
In today's data-driven world, SQL (Structured Query Language) is a blazing-hot skill. It's your...
The below code works for backup files only from local drives. When replaced with...
I have been asked to fine-tune the following SQL that was written by a...
In this scenario, I seek assistance in implementing row-level permissions for a table named...
What are the initial config sizes for the tempdb primary data files, secondary data files, and log files in SQL Server 2022?
See possible answers