SQLServerCentral.com Articles tagged Optimizer

Inside the Optimizer: Constructing a Plan - Part 4

Thu, 16 Sep 2010 06:00:00 UT

The final part in a series by Paul White exploring the internals of query optimization. Learn how

Inside the Optimizer: Constructing a Plan - Part 3

Tue, 14 Sep 2010 06:00:00 UT

Join Paul White in part three of a four-part series exploring the internals of query optimization as he looks at the rules that are used to build the execution plan.

Get alerts within 15 seconds of SQL Server issues
SQL Monitor checks performance data every 15 seconds, so you can fix issues before your users even notice them. Start monitoring with a free trial.

Inside the Optimizer: Constructing a Plan - Part 2

Thu, 09 Sep 2010 06:00:00 UT

How does the query optimizer build an execution plan for your queries? Paul White shows is in part two of a four-part series exploring the internals of query optimization.

‘Disturbing Development’
Grant Fritchey & the DBA Team present the latest installment of the Top 5 hard-earned lessons of a DBA – read it now

Inside the Optimizer: Constructing a Plan - Part 1

Tue, 07 Sep 2010 06:00:00 UT

Part one of a four-part series exploring the internals of query optimization from T-SQL guru, Paul White.

Index Primer - Just what statistics are kept?

Wed, 28 Oct 2009 06:00:00 UT

An in-depth look at index statistics and how they are used by the optimizer by Josef Richberg.