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,465 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
During a demo of Redgate Monitor Enterprise to a customer, they asked about how...
By Steve Jones
SQL Bits 2025 was amazing, as always. It’s been my favorite conference to attend,...
By Rohit Garg
As data becomes the backbone of modern business, understanding how to manage and analyze...
Hi, Is it possible to upgrade from sql server 2008 to sql server 2022,...
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
Comments posted to this topic are about the item The Hidden Cost of MAXDOP:...
When does Microsoft recommend using a heap as a table structure (no clustered index)?
See possible answers