Content

• How statistics can affect query performance
• Reading statistics
• The mathematics behind statistics
• Understanding how to evaluate your SQL server: metrics to use
• Understanding the different Waits: ASYNC_NETWORK_IO, CXPACKET, PAGEIOLATCH ,SOS_SCHEDULER_YIELD and WRITELOG
• Reading execution plans
• Using Plan Cache for finding problematic queries
• Analyzing slow queries: missing indexes, implicit conversions, parameter sniffing, predicate issues
• How SQL Server uses indexes
• Clustered and Nonclustered indexes
• When to use inclusive indexes, filtered indexes or calculated indexes to accelerate queries
• Optimizing indexes using Plan Cache
• Proving that indexes have improved performance
• The challenge of missing indexes
• Partitioning
• Columnstore indexes