I talked a few posts ago about Automatic Sample Sizes for Statistics Updates. From SQL 2016 CU4 we've been able to override that. You can manually update a statistics...
2021-03-11 (first published: 2021-03-09)
371 reads
Use trace flag 8666 to view the statistics objects that the optimizer used to generate your execution plan.
2021-03-01
16 reads
Looking at how SQL Server samples your data when doing auto-stats updates. Part of a series on understanding statistics, to help you achieve optimal performance of your queries on...
2021-03-02 (first published: 2021-02-24)
334 reads
Having up to date statistics is vital for getting the best performance out of your queries. Even though SQL Server automatically updates statistics in the background for you, you...
2021-02-16
217 reads
If you work in the world of SQL Server you’ve almost certainly heard of dbatools. For those who haven’t, it’s an open source PowerShell module for automating literally hundreds...
2021-04-20 (first published: 2021-02-15)
451 reads
For most of us in the Northern Hemisphere the clocks go foward next month and we get to look forward to longer, sunnier evenings. This post is a reminder...
2021-02-17 (first published: 2021-02-10)
444 reads
I’ve mentioned previously how not having up to date statistics can cause problems in query performance. This post looks at something called the Ascending Key Problem which can badly...
2021-02-09
170 reads
Statistics are vitally important in allowing SQL Server to find the most efficient way to execute your queries. In this post we learn more about them, what they are...
2021-03-24 (first published: 2021-02-01)
390 reads
When you don't have statistics, what does SQL use to calculate the estimated number of rows?
2021-02-04 (first published: 2021-01-26)
287 reads
Statistics objects are important for allowing the SQL Server Optimizer to make good estimates and form efficient execution plans. Related to that it's useful for us to understand when...
2021-01-25 (first published: 2021-01-18)
486 reads
Script to identify the most expensive queries on your database server using the Query...
In this post we're going to go through the steps to set up Always...
I’ve been using Azure SQL Database for quite some while and have set up...
I'm looking for best practice here and these are Azure VMs by the way....
Does anyone know if Azure absolutely requires windows clustered services to support availability groups?...
Comments posted to this topic are about the item Build a Better WordPress Archives...
Ask SSC