Clustered and Non-Clustered Indexes
How to check SQL Server clustered indexes, non-clustered indexes, index seek/scan, and execution plans
How to check SQL Server clustered indexes, non-clustered indexes, index seek/scan, and execution plans
Overview of deadlocks, query patterns that cause them, and countermeasures
SQL Server index fragmentation, reorganization, rebuilding, and concerns about using GUIDs as primary keys
Causes, impact, and solutions for parameter sniffing issues in SQL Server