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

HP is the 2019 Laptop Winner

By

This is for me, not necessarily for you, but I decided to go with...

Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 4

By

This is the fourth and final post in a series about modern Data Lake...

SQLOrlando 2019

By

We just had our final event of the year and looking back, not bad...

Read the latest Blogs

Forums

Before Installing hp laserjet m1005 driver check Internet Speed

By Celina Disuza

Your internet speed must be good to install the hp laserjet m1005 driver as installation takes...

Effectively Deal With Facebook Username Related Problems at Facebook Number

By Celina Disuza

Aren’t you aware of the quick fix solution to deal with your Facebook username...

Actively running Resource Hogs

By Steve-105283

I recently had an experience where I identified that there was a significant hole...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers