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.

Subscribe to Download

File Size959.55 KB
Create DateDecember 19, 2017
Last UpdatedDecember 19, 2017