9
votes
1answer
607 views

Slot Array and Total Page Size

I continue to read in many forums and on many blogs that a page is comprised as shown below: Page Size: 16 x 512B = 8192B Page Header: = 96B Maximum In_Row Row: = 8060B This leaves ...
4
votes
1answer
130 views

Why does my heap not fill its pages completely while an identical clustered index can fill to m_freeCnt = 0?

-- Example 1: With Clustered Index CREATE TABLE tbl5 ( i VARCHAR(900) NOT NULL ) ; GO CREATE CLUSTERED INDEX CIX_tbl5 ON tbl5 (i ASC) ; GO INSERT INTO tbl5 ( i ) VALUES ...