Here is another popular lab from Hands-On-Lab library: SQL Server Advanced Index Operations.
This lab is divided into four exercises, and in each of this exercise we will explore one advanced index operation. In the first exercise we will look at dynamic index seek operation. In the second exercise we will look at index union operation. In the third exercise we will look at index intersection operation and in the fourth exercise we will look a special case of index update operation.
Exercise 1: Dynamic Index Seek
Exercise 2: Index Union
Exercise 3: Index Intersection
Exercise 4: Index Update
SQLMaestros Hands-On-Labs enables the practical way of learning. Each lab document consists of multiple exercises and each exercise consists of multiple tasks. Apart from step-by-step instructions, the HOL document contains images, explanations, observations, notes, tips & tricks to ensure a great learning experience. With each lab, you can practice a specific concept step-by-step. With our HOL documents, you will get hands-on with hundreds of topics in SQL Server & Microsoft Data Platform. Learn More.