Tagged Questions
9
votes
1answer
319 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
99 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
...
