Actually, I pity the SQL Server that has to create Spools in order to handle nasty queries. But that is too long for a title. The title is a lie. With that being said, spools may appear in specific situations,… Read More ›
#queryperformance #executionplans
Not All Seeks Are Created Equal #1
Seeks seeks seeks… The number of the beast. Seeks are cool though. I like seeks. Sometimes, at least. Perhaps some seeks are cooler than others. I just said seeks six times, now we’re ready to go. Let’s begin by creating… Read More ›
The Execution Plan Saga #2: Scans
Scan operations are processed on account of data reading operators that differ according to the underlying data structure: Clustered Index Scan: Scan is done on the leaf-level pages of a Clustered Index Index Scan (NonClustered): Scan is done on the… Read More ›