Note: Lifetime Access
Abstract: Understanding the SQL Server indexing architecture is critical if you intend to tune your queries. How is the data stored? How does the B-Tree structure help the engine get to the data faster? What’s the difference between clustered and non-clustered indexes? What’s the purpose of the INCLUDE keyword? Hows does the Optimizer decide which access method to deploy? The difference between scan and seek operation. All such questions will get answered in this 60-minute demo-packed session. This is a level 100 session meant for folks who are just getting started with SQL Server. Experienced folks can join too if you need a refresher.