Execution Plans

Operator of the Week - Lazy Spool

  • Article

Continuing to illuminate the depths of SQL Server's Query Optimizer, Fabiano shines a light on the sixth major Showplan Operator on his list: the Lazy Spool. What does the Lazy Spool do that's so special, how does the Query Optimizer use it, and why is it so Lazy? Fabiano Amorim explains all.


2,774 reads

Controlling Execution Plans with Hints

  • Article

The Query Optimizer gets it right most of the time, but occasionally it chooses a plan that isn't the best possible. You can give the Query Optimiser a better idea by using Table, Join and Query hints. These come with a risk: Any choices you force on the Optimizer by using hints can turn out to be entirely wrong as the database changes with the addition of data over time. Grant Fritchey, in a chapter from his highly acclaimed book, explains further.


3,275 reads


Last Week Reading (2019-06-16)


Hello Data girls and guys! A lot of Microsoft’s announcements in many areas of...

Back with new focus


Back with a new focus First let me say wow can’t believe that it...

A Double Day


I’m traveling back from Australia today. A few weeks ago I lost a day...

Read the latest Blogs


Statistics Profile Results

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Statistics Profile Results

Temporary data and Differential Backup size

By Thomas Franz

Comments posted to this topic are about the item Temporary data and Differential Backup...

Watching Out for Deferred Name Resolution

By Tony Davis

Comments posted to this topic are about the item Watching Out for Deferred Name...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers