2019-05-02
533 reads
statistics (data)
2019-04-23
588 reads
Why Not Just Create Statistics?
Erik Darling looks at why you should be more interested in up to date statistics, and also why statistics outside of indexes aren’t really the most helpful thing.
2016-08-18
4,899 reads
2016-06-15
1,219 reads
2016-06-10
1,339 reads
2016-02-24
1,456 reads
Custom Built Statistics
Dan Holmes shows how you can create statistics exactly the way you want within the bounds of the 200 steps available.
2015-12-09
2,745 reads
2014-11-18
1,502 reads
Getting the Most out of Statistics
Statistics keep track of our data and will tell SQL Server how to make the best optimization decisions. Knowing how they work can make understanding query and performance problems much easier!
2014-06-09
5,257 reads
2014-05-02 (first published: 2014-04-09)
1,741 reads
Blogs
SQLSaturday Automatic Messages
By Andy Warren
For those who haven’t used the admin tools for SQLSaturday when an event is...
Using the Announcement/News Part of SQLSaturday
By Andy Warren
One of the interesting but not often used features of the SQLSaturday tools is...
SQLSaturday Orlando 2019 Begins
By Andy Warren
We’ll be event number 911, set for September 28th at our usual location at...
Forums
Statistics Profile Results
Comments posted to this topic are about the item Statistics Profile Results
Transaction was deadlocked on lock | communication buffer resources with another
I have a table that contains case numbers. The following stored procedure assigns a...
Microsoft and Oracle Cloud Partnership
Comments posted to this topic are about the item Microsoft and Oracle Cloud Partnership
Ask SSC