Database Reference
In-Depth Information
Listing 4-27 shows the partial
DBCC PAGE
command results. You can use the same technique, described in
Chapter 1, to obtain a page number for the row.
Listing 4-27.
Row Compression: DBCC PAGE results
Slot 0 Offset 0x60 Length 2033
Record Type = (COMPRESSED) PRIMARY_RECORD
Record attributes = LONG DATA REGION
Record size = 2033
CD Array
CD array entry=Column 1 (cluster 0, CD array offset 0): 0x01 (EMPTY)
CD array entry=Column 2 (cluster 0, CD array offset 0): 0x05 (FOUR_BYTE_SHORT)
CD array entry=Column 3 (cluster 0, CD array offset 1): 0x00 (NULL)
CD array entry=Column 4 (cluster 0, CD array offset 1): 0x04 (THREE_BYTE_SHORT)
CD array entry=Column 5 (cluster 0, CD array offset 2): 0x0a (LONG)
CD array entry=Column 6 (cluster 0, CD array offset 2): 0x01 (EMPTY)
CD array entry=Column 7 (cluster 0, CD array offset 3): 0x0b (BIT_COLUMN)
CD array entry=Column 8 (cluster 0, CD array offset 3): 0x00 (NULL)
CD array entry=Column 9 (cluster 0, CD array offset 4): 0x0a (LONG)
CD array entry=Column 10 (cluster 0, CD array offset 4): 0x0a (LONG)
Record Memory Dump
0EA4A060: 210a5140 1a0baaff ffffff61 61610103 00e803d0 !.Q@..ªÿÿÿÿaaa...è.Ð
0EA4A074: 07da0762 62626262 62626262 62626262 62626262 .Ú.bbbbbbbbbbbbbbbbb
<SKIPPED>
0EA4A448: 62626262 62626262 62626262 62626262 62626262 bbbbbbbbbbbbbbbbbbbb
0EA4A45C: 62626263 63636363 63636363 63636363 63636363 bbbccccccccccccccccc
0EA4A470: 63636363 63636363 63636363 63636363 63636363 cccccccccccccccccccc
<SKIPPED>
0EA4A830: 63636363 63636363 63636363 63636363 63636363 cccccccccccccccccccc
0EA4A844: 63636364 64646464 64646464 64 cccdddddddddd
Slot 0 Column 1 Offset 0x0 Length 4 Length (physical) 0
Int1 = 0
Slot 0 Column 2 Offset 0x7 Length 4 Length (physical) 4
Int2 = 2147483647
Slot 0 Column 3 Offset 0x0 Length 0 Length (physical) 0
Int3 = [NULL]
Slot 0 Column 4 Offset 0xb Length 3 Length (physical) 3
VarChar1 = aaa
Slot 0 Column 5 Offset 0x17 Length 1000 Length (physical) 1000
VarChar2 = bbbbbbbbbbbbbbbbbbbbbbbbbbbbb <SKIPPED>
Slot 0 Column 6 Offset (see CD array entry) Length 1
Bit1 = 0
Slot 0 Column 7 Offset (see CD array entry) Length 1
Bit2 = 1
Slot 0 Column 8 Offset 0x0 Length 0 Length (physical) 0
Char1 = [NULL]
Slot 0 Column 9 Offset 0x3ff Length 1000 Length (physical) 1000
Char2 = cccccccccccccccccccccccccccccccc <SKIPPED>
Slot 0 Column 10 Offset 0x7e7 Length 1000 Length (physical) 10
Char3 = dddddddddd
