statistics (data)

Statistics on Ascending Columns

  • Article

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

13 Things You Should Know About Statistics and the Query Optimizer

  • Article

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

Blogs

Basic XML Queries–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Don’t Stop at Just Enabling Read Committed Snapshot Isolation (RCSI)

By

This past week I had a great Client ask an even greater question, and...

Query Compile Time

By

A question that came up recently was how to track the query compile time....

Read the latest Blogs

Forums

SELECT column based on parameter

By tshad

Is there a way in the same SELECT statement to show different columns without...

Restore WITH RECOVERY freezing on source DB after tail of log backup

By J-M.L

Hello everyone, I've encountered this scenario twice so far and I still don't understand...

SQL SMO property to determine if server is named or default instance

By TangoVictor

I'm using my registered server list to generate a collection of servers in powershell. The...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers