The Vocabulary of Performance Tuning
Duration: 60 minutes
Track: Application & Database Development
This session is for the absolute beginner to learn the terminology of performance tuning and how queries are processed. This includes how queries are Parsed, Resolved, Optimized, Compiled and Executed. We will see how this effects Batches, Transactions, and Errors. We will also briefly discuss table structures and the differences between Heaps and Clustered Indexes. The session is led by an expert Microsoft Certified Trainer (MCT) and Microsoft MVP who regularly teaches the SQL Server certification courses.