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

Good to see you at Houston Tech Fest 2019!

By

It was awesome to see a great crowd at the triumphant return of Houston...

Using kubectl logs to read the SQL Server Error Log in Kubernetes

By

When working with SQL Server running containers the Error Log is written to standard...

Using Powershell for SQL Saturday Logos

By

Out of necessity are born the tools of laziness.  This is a good thing. ...

Read the latest Blogs

Forums

2nd Server min requirements for transaction log shipping & reducing license cost

By guht

I will have a 64-bit 2008 R2 SQL Server Standard edition acting as the...

how to hide the passsword in the log file when the package fails.

By mcfarlandparkway

I have an encryption and decryption package and the keyId public and private from...

CREATE DATABASE 3 seconds for one server, 72 for the other?

By iosman123

Hello,   We have two IaaS VMs in Azure and a CREATE DATABASE statement...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers