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
793 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,898 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,890 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,603 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,662 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,170 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,595 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,690 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,351 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)
38,012 reads
Blogs
A Pursuit of Lifelong Learning
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
Advice I Like: Time and Focus
By Steve Jones
“You don’t need more time because you already have all the time that you...
Book Review: Microsoft 365 Copilot and Agent Administration Fundamentals
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Forums
Alamat BCA KCP Ciceri Telp:0821°8200°233
Telp/Wa 628218200233 Jl. Jend. Sudirman No.38, Sumurpecung, Kec. Serang, Kota Serang, Banten 42118
Alamat BCA KCP Citra Raya Telp:0821°7555°651
Telp/Wa 628217555651 Perumahan Citra Raya Blok KD.02 No. 10, 15, RW.Mardigrass, Mekar Bakti, Kec....
MiniMax m3 and SQL Server
Comments posted to this topic are about the item MiniMax m3 and SQL Server
Question of the Day
SQL Server Vector Support I
What are vectors in SQL Server 2025, as related to the new AI features?
See possible answers