Here is another popular lab from Hands-On-Lab library: SQL Server Statistics Internals.
Statistics are mainly used by the query optimizer to estimate no. of rows a query returns. In the first exercise of this Lab, we will explore different types of statistics. In the second exercise, we will look at how statistics works and a different component of statistics. And in the third exercise, we will explore update of statistics and different database level configuration related to updating statistics.
Exercise 1: Statistics Overview
Exercise 2: Statistics Internals
Exercise 3: Statistics 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.
Happy Learning – The Practical Way.