Performance Tuning Quizzes

Memory

Memory Concepts and Management

Windows Memory Concepts

Troubleshooting Memory Waits in SQL Server

Execution plans

Execution Plan Basics

Physical Join Operators in Execution Plans

Hash Joins

Parallelism

Wait stats

CXPACKET, CXCONSUMER, and Parallelism

Wait Types in SQL Server

Statistics

Statistics

Guess the Statistics Estimate

UPDATE STATISTICS WITH… WAT???

Hints and trace flags

Hints in TSQL

Trace Flag Trivia

Performance tools

Query Store Basics

Transact SQL Debugger

Query tuning

Parameter Sniffing