I am using SQL Server version: Microsoft SQL Server 2012 - 11.0.2100.60 (X64).
I created a single table containing one and only one integer-valued column. I then added one and only one row to the table.
CREATE DATABASE SQLServerInternals; GO USE SQLServerInternals; GO CREATE TABLE page_header ( c1 INT IDENTITY NOT NULL ) ON [PRIMARY]; GO INSERT INTO page_header DEFAULT VALUES; GO DBCC IND(SQLServerInternals,page_header,1); GO DBCC TRACEON(3604); GO DBCC PAGE (SQLServerInternals,1,231,2); GO
Here is the output from DBCC PAGE.
Does anyone know what the DB Frag ID = 1 means and whether it is the value 0x0100 that I see in bytes 64-65? I assume that the value is at most a SMALLINT type. I assume that the remaining bytes are for "future use".
DBCC PAGE
. It still saysDB Frag ID = 1
regardless of what I set it tosys.sysrscols
used to have a column calleddbfragid
but this no longer exists in 2012. So I wonder if it was always there. Just changed location.