Page Free Space

Parallel Index Building Execution Plan SQL Server doesn't support parallel modifications to a b-tree index. That might sound surprising....

Allocation Order Scans When an execution plan includes a scan of a b-tree index structure, the storage engine may be ab...

So…is it a Seek or a Scan? You might be most familiar with the terms ‘Seek’ and ‘Scan’ from the graphical plans produce...

A Tale of Two Index Hints If you look up Table Hints in the official documentation, you’ll find the following stateme...