SQL Server Heap and PT
Heap is table without a clustered Index. But it may contain primary key and also non-clustered indexes. In SQL Server 2005 data is stored within tables. Data within a table is grouped together into allocation units based on their column data types, what it means is one kind of data types is stored together in allocation units. Data within this allocation unit is stored in pages. Each page is of 8KB size. Group of 8 pages is stored together and they are referred as Extent. Pages within a table store the data rows with structure which helps to search/locate data faster. If the data of table is not logically sorted, in other word there is no order of data specified in table it is called as Heap Structure. Here I just put an excellent ref of Brent presented by Kendra related to SQL Server Heap and its associated performance monitoring --Author: Brent Ozar PLF, LLC -- --Purpose: Demo some of the peculiarities of heaps in SQL Server. --This script is for use on...