A heap is a table without a clustered index. One or more non-clustered indexes can be created on a heap. This lab is divided into three exercises. In the first exercise we will look at different types of allocation units available in SQL Server. In the second exercise we will observe how page modification is done in a heap and in the third exercise we will troubleshoot I/O issues related to page modification in heap. This lab is divided into three exercises.

Subscribe to Download


Version
Download230
File Size97.89 KB
Create DateAugust 25, 2016
Last UpdatedSeptember 7, 2016
Extended Event Part 1
Installing SQL Server 2014