Here is another popular lab from Hands-On-Lab library: SQL Server Advanced Query Tuning.
This lab talks about a very common yet difficult problem, finding TOP n rows per group. The problem may seem easy, however in this lab we’ll discuss multiple ways to solve this problem and compare the different ways on performance to find out the fastest way to solve the problem. In the first exercise, we’ll talk about TOP use cases and in the second exercise we’ll talk about the Top n rows per group problem and it’s different solutions.
Exercise 1: Use Cases Of TOP
Exercise 2: Query Tuning Techniques
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.