- dbcc page('dbpage', 1, 309, 3)
- -------------------------------------------------------------------------------------------------页头信息省略中...
- Slot 0 Offset 0x60 Length 3059
- /*
- Slot 槽位号,一个槽位一行数据,这一行数据从 0x60 = 96开始,长度是 3059 bytes
- */
- Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS Record Size = 3059 Memory Dump@0x000000002BB78060
- /*下文为这一行记录 3059个字节内容*/
- 0000000000000000 : 30000800 01000000 0400a003 002b80e3 0bf38b02 0............ + ......0000000000000014 : 00000001 000000d5 69000070 17000033 01000001........i..p...3....0000000000000028 : 00000028 72707429 2c594553 204f5220 4e4f2c53... (rpt),
- YES OR NO,
- S 000000000000003C: 59535245 4d4f5445 4c4f4749 4e532054 59504553 YSREMOTELOGINS TYPES 0000000000000050 : 2c535953 52454d4f 54454c4f 47494e53 20545950,
- SYSREMOTELOGINS TYP 0000000000000064 : 45532028 55504441 5445292c 41463a20 61676772 ES(UPDATE),
- AF: aggr 0000000000000078 : 65676174 65206675 6e637469 6f6e2c41 503a2061 egate
- function,
- AP: a中间省略...0000000000000BB8: 2c6e756d 65726963 20726f75 6e646162 6f72742c,
- numeric roundabort,
- 0000000000000BCC: 7072696d 61727920 6b65792c 616e7369 5f6e756c primary key,
- ansi_nul 0000000000000BE0: 6c5f6400 00d10700 00000031 01000001 000100 l_d........1.......
- /*下文为 在槽位0 slot 0 的 这一行记录 ,详细描述每一列的存储情况*/
- Slot 0 Column 1 Offset 0x4 Length 4 Length(physical) 4
- /*slot 0,第一列 在本页占用4字节,列名为id,值为1*/
- id = 1
- namea = [BLOB Inline Root] Slot 0 Column 2 Offset 0x13 Length 24 Length(physical) 24
- /*slot 0,第2列,本页占用24字节,列名为namea
- 这里可以看到是发生了行溢出情况,列中没有数据,但是存储了该列的实际位置
- 实际大小为6000字节,值 存储在第一个文件第307页的 slot 0 槽位上*/
- Level = 0 Unused = 0 UpdateSeq = 1 TimeStamp = 1775566848 Type = 2 Link 0
- Size = 6000 RowId = (1 : 307 : 0)
- Slot 0 Column 3 Offset 0x2b Length 3000 Length(physical) 3000
- nameb = (rpt),
- YES OR NO,
- SYSREMOTELOGINS TYPES,
- SYSREMOTELOGINS TYPES(UPDATE),
- AF: aggregate
- function,
- AP: applicati on,
- C: check cns,
- ...省略中...primary key,
- ansi_null_d
- /*slot 0,第3列 ,本页占用3000字节,列名为nameb ,值为 nameb= 的后面一大段中*/
- descriptions = [Textpointer] Slot 0 Column 4 Offset 0xbe3 Length 16 Length(physical) 16
- /*slot 0,第4列 ,该列为text数据类型,本页占用16字节,列名为descriptions,其值存储在第一个文件的第305页的 slot 1 槽位上*/
- TextTimeStamp = 131137536 RowId = (1 : 305 : 1)
- Slot 0 Offset 0x0 Length 0 Length(physical) 0
- /*该表格有主键 ,该行的keyhashvalue值*/
- KeyHashValue = (8194443284a0)
来源: http://www.cnblogs.com/xinysu/p/6797589.html