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

Social: Going Along to Get Along

By

It’s the eve of the Fourth of July, when the Declaration of Independence is...

Daily Coping 3 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Using Docker Volumes for SQL Server in Linux

By

No, not that kind of volume! Over the past couple of blog posts, I...

Read the latest Blogs

Forums

www.dumps-bin.top Dumps Shop Online 2020 - Sell Dumps with pin - Legit dumps

By dumpsbintop

Hello , I wanna present automated secure dumps shop service with high quality dumps....

Keto Boost Plus

By nqwdsabhukmp

https slimketoboost com/keto-boost-plus/  

Compare sql-2012 and sql-2016 settings

By rohitkocharda

Hi everyone, W are just doing a migration from sql 2012 enterprise  to sql...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers