SET STATISTICS IO TIME ON

OPTION MAXDOP 1

Redundant Indexes in SQL Server

SET STATISTICS IO TIME ON

Convert HASH to STREAM – ORDER GROUP Query Hint

NO_PERFORMANCE_SPOOL Query Hint

Troubleshooting High CPU Usage

Removing Table Spool Operator (NO_PERFORMANCE_SPOOL)

Reading SQL Server Error Log

RESOURCE WAIT TIME

Running Total Better Coding

Baselining Wait Statistics

SQL Server Wait Types – Part 4

SQL Server Running Total (Basic)

SQL Server Data Time Functions

Undocumented Stored Procedures

SQL Server Wait Types Part 3

Better T-SQL for Running Total?

SQL Server OSTRESS Utility

How Many Wait Types?

MISSING WAITS (CXCONSUMER)

SQL Server Wait Types Part 2

What is your SQL Server Query doing?

SQL Server Eager Index Spool (Short)

INEQUALITY with SCAN vs EQUALITY with SEEK