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
798 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
798 reads
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,902 reads
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,895 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,607 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,668 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
11,200 reads
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,611 reads
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,714 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,362 reads
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,116 reads
By Steve Jones
semaphorism – n. a conversational hint that you have something personal to say on...
This week I was at PASS Data Community Summit in Seattle, and I attended...
By James Serra
(This is the third post in a three-part series on how AI is changing...
Ruko Grand Panglima Polim, Jl. Panglima Polim No.16-17, RT.2/RW.1, Pulo, Kec. Kby. Baru, Kota...
WhatsApp:0817819444 Jl. Brawijaya 79, Dusun Muncar Baru, Tembokrejo, Kec. Muncar, Kabupaten Banyuwangi, Jawa Timur...
Comments posted to this topic are about the item Server-level Roles
In SQL Server 2025, can I alter a fixed server role?
See possible answers