If you need to optimise SQL Server performance, it pays to understand SQL Server Statistics. Grant Fritchey answers some frequently-asked questions about SQL Server Statistics: the ones we somehow feel silly asking in public, and think twice about doing so.
2013-03-12
3,545 reads
If you need to optimise SQL Server performance, it pays to understand SQL Server Statistics. Grant Fritchey answers some frequently-asked questions about SQL Server Statistics: the ones we somehow feel silly asking in public, and think twice about doing so.
2013-03-01
4,125 reads
2012-11-06
1,928 reads
2012-10-09
2,477 reads
How can I find out which statistics are outdated in my SQL Server database?
2012-09-06
3,505 reads
2011-09-23
2,464 reads
It comes as rather a shock to find out that one of the commonest circumstances in an OLTP database, an ascending primary key with most querying on the latest records, can throw the judgement of the Query Optimiser to the extent that perfomance nose-dives. Fabiano Amorim once again dons snorkel and goggles to explore the murky depths of execution plans to find out why.
2011-09-16
2,528 reads
SQL Server Statistics assist the query optimiser to calculate the best way of running the query. Holger describes every common way that things can go wrong with statistics, and how to put matters right.
2010-11-11
3,714 reads
2010-04-16
3,718 reads
Fabiano launches into a sound technical explanation of the way that the query optimiser works in SQL Server with a mention of Brazilian Soccer stars and young ladies on Copacabana beach. You'll never quite think of statistics, execution plans, and the query optimiser the same way again after reading this, but we think you'll understand them better.
2010-02-02
5,853 reads
By Steve Jones
As a part of the Book of Redgate, we have a series of (red,...
I recently had a new pipeline fail. It was actually a copy of an...
By Chris Yates
Microsoft Fabric is transforming real-time analytics for financial institutions. It provides a unified data...
Hi If value is 21000030 it should return 4 not 5 . In first...
This is one of those things very hard (for me)to explain in words. See...
Comments posted to this topic are about the item Feeling your age? How would...
Can I rollback a cumulative update and remove it from my SQL Server instance?
See possible answers