SQLSERVER2008启用了压缩的数据页面内容
SQLSERVER2008启用了压缩的数据页面内容
CD Array=compressed data array
页面压缩
1 USE [pratice] 2 GO 3 --DROP TABLE ClusteredTable 4 CREATE TABLE ClusteredTable 5 ( id INT, 6 col2 CHAR(999), 7 col3 VARCHAR(10) 8 )WITH (DATA_COMPRESSION = PAGE) 9 10 11 DECLARE @i INT 12 SET @i=1 13 WHILE(@i<32) 14 BEGIN 15 INSERT INTO [dbo].[ClusteredTable] ( [id], [col2], [col3] ) 16 VALUES(@i,'xxx','') 17 SET @i=@i+2 18 END 19 20 SELECT * FROM ClusteredTable 21 22 SELECT * FROM sys.dm_db_index_physical_stats (DB_ID ('pratice'),OBJECT_ID('ClusteredTable') , 23 NULL, NULL, 'SAMPLED'); 24 25 TRUNCATE TABLE [dbo].[DBCCResult] 26 INSERT INTO DBCCResult EXEC ('DBCC IND(pratice,ClusteredTable,-1) ') 27 28 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC 29 30 DBCC TRACEON(3604,-1) 31 GO 32 DBCC PAGE([pratice],1,13945,3) 33 GO
1 DBCC 执行完毕。如果 DBCC 输出了错误信息，请与系统管理员联系。 2 3 PAGE: (1:13945) 4 5 6 BUFFER: 7 8 9 BUF @0x0000000004CC3A80 10 11 bpage = 0x00000001B058C000 bhash = 0x0000000000000000 bpageno = (1:13945) 12 bdbid = 8 breferences = 0 bcputicks = 0 13 bsampleCount = 0 bUse1 = 970 bstat = 0x10b 14 blog = 0x15ab21cc bnext = 0x0000000000000000 15 16 PAGE HEADER: 17 18 19 Page @0x00000001B058C000 20 21 m_pageId = (1:13945) m_headerVersion = 1 m_type = 1 22 m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x8000 23 m_objId (AllocUnitId.idObj) = 258 m_indexId (AllocUnitId.idInd) = 256 24 Metadata: AllocUnitId = 72057594054836224 25 Metadata: PartitionId = 72057594047102976 Metadata: IndexId = 0 26 Metadata: ObjectId = 1058102810 m_prevPage = (0:0) m_nextPage = (0:0) 27 pminlen = 4 m_slotCnt = 16 m_freeCnt = 7920 28 m_freeData = 240 m_reservedCnt = 0 m_lsn = (2561:18430:2) 29 m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0 30 m_tornBits = 0 DB Frag ID = 1 31 32 Allocation Status 33 34 GAM (1:2) = ALLOCATED SGAM (1:3) = ALLOCATED 35 PFS (1:8088) = 0x61 MIXED_EXT ALLOCATED 50_PCT_FULL DIFF (1:6) = CHANGED 36 ML (1:7) = NOT MIN_LOGGED 37 38 Slot 0 Offset 0x60 Length 9 39 40 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 41 42 CD Array 43 44 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 45 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 46 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 47 Record Memory Dump 48 49 000000005666A060: 01034211 81787878 40 ..B..xxx@ 50 51 Slot 0 Column 1 Offset 0x4 Length 4 Length (physical) 1 52 53 id = 1 54 55 Slot 0 Column 2 Offset 0x5 Length 999 Length (physical) 3 56 57 col2 = xxx 58 59 60 61 62 63 64 65 66 67 Slot 0 Column 3 Offset 0x0 Length 0 Length (physical) 0 68 69 col3 = 70 71 Slot 1 Offset 0x69 Length 9 72 73 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 74 75 CD Array 76 77 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 78 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 79 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 80 Record Memory Dump 81 82 000000005666A069: 01034211 83787878 40 ..B..xxx@ 83 84 Slot 1 Column 1 Offset 0x4 Length 4 Length (physical) 1 85 86 id = 3 87 88 Slot 1 Column 2 Offset 0x5 Length 999 Length (physical) 3 89 90 col2 = xxx 91 92 93 94 95 96 97 98 99 100 Slot 1 Column 3 Offset 0x0 Length 0 Length (physical) 0 101 102 col3 = 103 104 Slot 2 Offset 0x72 Length 9 105 106 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 107 108 CD Array 109 110 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 111 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 112 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 113 Record Memory Dump 114 115 000000005666A072: 01034211 85787878 40 ..B..xxx@ 116 117 Slot 2 Column 1 Offset 0x4 Length 4 Length (physical) 1 118 119 id = 5 120 121 Slot 2 Column 2 Offset 0x5 Length 999 Length (physical) 3 122 123 col2 = xxx 124 125 126 127 128 129 130 131 132 133 Slot 2 Column 3 Offset 0x0 Length 0 Length (physical) 0 134 135 col3 = 136 137 Slot 3 Offset 0x7b Length 9 138 139 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 140 141 CD Array 142 143 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 144 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 145 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 146 Record Memory Dump 147 148 000000005666A07B: 01034211 87787878 40 ..B..xxx@ 149 150 Slot 3 Column 1 Offset 0x4 Length 4 Length (physical) 1 151 152 id = 7 153 154 Slot 3 Column 2 Offset 0x5 Length 999 Length (physical) 3 155 156 col2 = xxx 157 158 159 160 161 162 163 164 165 166 Slot 3 Column 3 Offset 0x0 Length 0 Length (physical) 0 167 168 col3 = 169 170 Slot 4 Offset 0x84 Length 9 171 172 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 173 174 CD Array 175 176 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 177 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 178 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 179 Record Memory Dump 180 181 000000005666A084: 01034211 89787878 40 ..B..xxx@ 182 183 Slot 4 Column 1 Offset 0x4 Length 4 Length (physical) 1 184 185 id = 9 186 187 Slot 4 Column 2 Offset 0x5 Length 999 Length (physical) 3 188 189 col2 = xxx 190 191 192 193 194 195 196 197 198 199 Slot 4 Column 3 Offset 0x0 Length 0 Length (physical) 0 200 201 col3 = 202 203 Slot 5 Offset 0x8d Length 9 204 205 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 206 207 CD Array 208 209 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 210 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 211 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 212 Record Memory Dump 213 214 000000005666A08D: 01034211 8b787878 40 ..B..xxx@ 215 216 Slot 5 Column 1 Offset 0x4 Length 4 Length (physical) 1 217 218 id = 11 219 220 Slot 5 Column 2 Offset 0x5 Length 999 Length (physical) 3 221 222 col2 = xxx 223 224 225 226 227 228 229 230 231 232 Slot 5 Column 3 Offset 0x0 Length 0 Length (physical) 0 233 234 col3 = 235 236 Slot 6 Offset 0x96 Length 9 237 238 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 239 240 CD Array 241 242 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 243 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 244 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 245 Record Memory Dump 246 247 000000005666A096: 01034211 8d787878 40 ..B..xxx@ 248 249 Slot 6 Column 1 Offset 0x4 Length 4 Length (physical) 1 250 251 id = 13 252 253 Slot 6 Column 2 Offset 0x5 Length 999 Length (physical) 3 254 255 col2 = xxx 256 257 258 259 260 261 262 263 264 265 Slot 6 Column 3 Offset 0x0 Length 0 Length (physical) 0 266 267 col3 = 268 269 Slot 7 Offset 0x9f Length 9 270 271 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 272 273 CD Array 274 275 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 276 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 277 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 278 Record Memory Dump 279 280 000000005666A09F: 01034211 8f787878 40 ..B..xxx@ 281 282 Slot 7 Column 1 Offset 0x4 Length 4 Length (physical) 1 283 284 id = 15 285 286 Slot 7 Column 2 Offset 0x5 Length 999 Length (physical) 3 287 288 col2 = xxx 289 290 291 292 293 294 295 296 297 298 Slot 7 Column 3 Offset 0x0 Length 0 Length (physical) 0 299 300 col3 = 301 302 Slot 8 Offset 0xa8 Length 9 303 304 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 305 306 CD Array 307 308 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 309 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 310 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 311 Record Memory Dump 312 313 000000005666A0A8: 01034211 91787878 40 ..B..xxx@ 314 315 Slot 8 Column 1 Offset 0x4 Length 4 Length (physical) 1 316 317 id = 17 318 319 Slot 8 Column 2 Offset 0x5 Length 999 Length (physical) 3 320 321 col2 = xxx 322 323 324 325 326 327 328 329 330 331 Slot 8 Column 3 Offset 0x0 Length 0 Length (physical) 0 332 333 col3 = 334 335 Slot 9 Offset 0xb1 Length 9 336 337 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 338 339 CD Array 340 341 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 342 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 343 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 344 Record Memory Dump 345 346 000000005666A0B1: 01034211 93787878 40 ..B..xxx@ 347 348 Slot 9 Column 1 Offset 0x4 Length 4 Length (physical) 1 349 350 id = 19 351 352 Slot 9 Column 2 Offset 0x5 Length 999 Length (physical) 3 353 354 col2 = xxx 355 356 357 358 359 360 361 362 363 364 Slot 9 Column 3 Offset 0x0 Length 0 Length (physical) 0 365 366 col3 = 367 368 Slot 10 Offset 0xba Length 9 369 370 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 371 372 CD Array 373 374 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 375 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 376 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 377 Record Memory Dump 378 379 000000005666A0BA: 01034211 95787878 40 ..B..xxx@ 380 381 Slot 10 Column 1 Offset 0x4 Length 4 Length (physical) 1 382 383 id = 21 384 385 Slot 10 Column 2 Offset 0x5 Length 999 Length (physical) 3 386 387 col2 = xxx 388 389 390 391 392 393 394 395 396 397 Slot 10 Column 3 Offset 0x0 Length 0 Length (physical) 0 398 399 col3 = 400 401 Slot 11 Offset 0xc3 Length 9 402 403 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 404 405 CD Array 406 407 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 408 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 409 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 410 Record Memory Dump 411 412 000000005666A0C3: 01034211 97787878 40 ..B..xxx@ 413 414 Slot 11 Column 1 Offset 0x4 Length 4 Length (physical) 1 415 416 id = 23 417 418 Slot 11 Column 2 Offset 0x5 Length 999 Length (physical) 3 419 420 col2 = xxx 421 422 423 424 425 426 427 428 429 430 Slot 11 Column 3 Offset 0x0 Length 0 Length (physical) 0 431 432 col3 = 433 434 Slot 12 Offset 0xcc Length 9 435 436 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 437 438 CD Array 439 440 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 441 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 442 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 443 Record Memory Dump 444 445 000000005666A0CC: 01034211 99787878 40 ..B..xxx@ 446 447 Slot 12 Column 1 Offset 0x4 Length 4 Length (physical) 1 448 449 id = 25 450 451 Slot 12 Column 2 Offset 0x5 Length 999 Length (physical) 3 452 453 col2 = xxx 454 455 456 457 458 459 460 461 462 463 Slot 12 Column 3 Offset 0x0 Length 0 Length (physical) 0 464 465 col3 = 466 467 Slot 13 Offset 0xd5 Length 9 468 469 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 470 471 CD Array 472 473 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 474 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 475 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 476 Record Memory Dump 477 478 000000005666A0D5: 01034211 9b787878 40 ..B..xxx@ 479 480 Slot 13 Column 1 Offset 0x4 Length 4 Length (physical) 1 481 482 id = 27 483 484 Slot 13 Column 2 Offset 0x5 Length 999 Length (physical) 3 485 486 col2 = xxx 487 488 489 490 491 492 493 494 495 496 Slot 13 Column 3 Offset 0x0 Length 0 Length (physical) 0 497 498 col3 = 499 500 Slot 14 Offset 0xde Length 9 501 502 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 503 504 CD Array 505 506 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 507 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 508 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 509 Record Memory Dump 510 511 000000005666A0DE: 01034211 9d787878 40 ..B..xxx@ 512 513 Slot 14 Column 1 Offset 0x4 Length 4 Length (physical) 1 514 515 id = 29 516 517 Slot 14 Column 2 Offset 0x5 Length 999 Length (physical) 3 518 519 col2 = xxx 520 521 522 523 524 525 526 527 528 529 Slot 14 Column 3 Offset 0x0 Length 0 Length (physical) 0 530 531 col3 = 532 533 Slot 15 Offset 0xe7 Length 9 534 535 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 536 537 CD Array 538 539 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 540 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 541 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 542 Record Memory Dump 543 544 000000005666A0E7: 01034211 9f787878 40 ..B..xxx@ 545 546 Slot 15 Column 1 Offset 0x4 Length 4 Length (physical) 1 547 548 id = 31 549 550 Slot 15 Column 2 Offset 0x5 Length 999 Length (physical) 3 551 552 col2 = xxx 553 554 555 556 557 558 559 560 561 562 Slot 15 Column 3 Offset 0x0 Length 0 Length (physical) 0 563 564 col3 = 565 566 567 DBCC 执行完毕。如果 DBCC 输出了错误信息，请与系统管理员联系。
行压缩
1 USE [pratice] 2 GO 3 --DROP TABLE ClusteredTable 4 CREATE TABLE ClusteredTablerow 5 ( id INT, 6 col2 CHAR(999), 7 col3 VARCHAR(10) 8 )WITH (DATA_COMPRESSION = ROW) 9 10 11 DECLARE @i INT 12 SET @i=1 13 WHILE(@i<32) 14 BEGIN 15 INSERT INTO [dbo].[ClusteredTablerow] ( [id], [col2], [col3] ) 16 VALUES(@i,'xxx','') 17 SET @i=@i+2 18 END 19 20 SELECT * FROM ClusteredTablerow 21 22 SELECT * FROM sys.dm_db_index_physical_stats (DB_ID ('pratice'),OBJECT_ID('ClusteredTablerow') , 23 NULL, NULL, 'SAMPLED'); 24 25 TRUNCATE TABLE [dbo].[DBCCResult] 26 INSERT INTO DBCCResult EXEC ('DBCC IND(pratice,ClusteredTablerow,-1) ') 27 28 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC 29 30 DBCC TRACEON(3604,-1) 31 GO 32 DBCC PAGE([pratice],1,13947,3) 33 GO
1 DBCC 执行完毕。如果 DBCC 输出了错误信息，请与系统管理员联系。 2 3 PAGE: (1:13947) 4 5 6 BUFFER: 7 8 9 BUF @0x0000000004CC8100 10 11 bpage = 0x00000001AC920000 bhash = 0x0000000000000000 bpageno = (1:13947) 12 bdbid = 8 breferences = 0 bcputicks = 0 13 bsampleCount = 0 bUse1 = 1490 bstat = 0x10b 14 blog = 0x21215acc bnext = 0x0000000000000000 15 16 PAGE HEADER: 17 18 19 Page @0x00000001AC920000 20 21 m_pageId = (1:13947) m_headerVersion = 1 m_type = 1 22 m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x8000 23 m_objId (AllocUnitId.idObj) = 259 m_indexId (AllocUnitId.idInd) = 256 24 Metadata: AllocUnitId = 72057594054901760 25 Metadata: PartitionId = 72057594047168512 Metadata: IndexId = 0 26 Metadata: ObjectId = 1074102867 m_prevPage = (0:0) m_nextPage = (0:0) 27 pminlen = 4 m_slotCnt = 16 m_freeCnt = 7920 28 m_freeData = 240 m_reservedCnt = 0 m_lsn = (2561:18458:2) 29 m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0 30 m_tornBits = 0 DB Frag ID = 1 31 32 Allocation Status 33 34 GAM (1:2) = ALLOCATED SGAM (1:3) = ALLOCATED 35 PFS (1:8088) = 0x61 MIXED_EXT ALLOCATED 50_PCT_FULL DIFF (1:6) = CHANGED 36 ML (1:7) = NOT MIN_LOGGED 37 38 Slot 0 Offset 0x60 Length 9 39 40 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 41 42 CD Array 43 44 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 45 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 46 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 47 Record Memory Dump 48 49 0000000058EDA060: 01034211 81787878 40 ..B..xxx@ 50 51 Slot 0 Column 1 Offset 0x4 Length 4 Length (physical) 1 52 53 id = 1 54 55 Slot 0 Column 2 Offset 0x5 Length 999 Length (physical) 3 56 57 col2 = xxx 58 59 60 61 62 63 64 65 66 67 Slot 0 Column 3 Offset 0x0 Length 0 Length (physical) 0 68 69 col3 = 70 71 Slot 1 Offset 0x69 Length 9 72 73 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 74 75 CD Array 76 77 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 78 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 79 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 80 Record Memory Dump 81 82 0000000058EDA069: 01034211 83787878 40 ..B..xxx@ 83 84 Slot 1 Column 1 Offset 0x4 Length 4 Length (physical) 1 85 86 id = 3 87 88 Slot 1 Column 2 Offset 0x5 Length 999 Length (physical) 3 89 90 col2 = xxx 91 92 93 94 95 96 97 98 99 100 Slot 1 Column 3 Offset 0x0 Length 0 Length (physical) 0 101 102 col3 = 103 104 Slot 2 Offset 0x72 Length 9 105 106 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 107 108 CD Array 109 110 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 111 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 112 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 113 Record Memory Dump 114 115 0000000058EDA072: 01034211 85787878 40 ..B..xxx@ 116 117 Slot 2 Column 1 Offset 0x4 Length 4 Length (physical) 1 118 119 id = 5 120 121 Slot 2 Column 2 Offset 0x5 Length 999 Length (physical) 3 122 123 col2 = xxx 124 125 126 127 128 129 130 131 132 133 Slot 2 Column 3 Offset 0x0 Length 0 Length (physical) 0 134 135 col3 = 136 137 Slot 3 Offset 0x7b Length 9 138 139 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 140 141 CD Array 142 143 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 144 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 145 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 146 Record Memory Dump 147 148 0000000058EDA07B: 01034211 87787878 40 ..B..xxx@ 149 150 Slot 3 Column 1 Offset 0x4 Length 4 Length (physical) 1 151 152 id = 7 153 154 Slot 3 Column 2 Offset 0x5 Length 999 Length (physical) 3 155 156 col2 = xxx 157 158 159 160 161 162 163 164 165 166 Slot 3 Column 3 Offset 0x0 Length 0 Length (physical) 0 167 168 col3 = 169 170 Slot 4 Offset 0x84 Length 9 171 172 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 173 174 CD Array 175 176 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 177 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 178 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 179 Record Memory Dump 180 181 0000000058EDA084: 01034211 89787878 40 ..B..xxx@ 182 183 Slot 4 Column 1 Offset 0x4 Length 4 Length (physical) 1 184 185 id = 9 186 187 Slot 4 Column 2 Offset 0x5 Length 999 Length (physical) 3 188 189 col2 = xxx 190 191 192 193 194 195 196 197 198 199 Slot 4 Column 3 Offset 0x0 Length 0 Length (physical) 0 200 201 col3 = 202 203 Slot 5 Offset 0x8d Length 9 204 205 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 206 207 CD Array 208 209 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 210 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 211 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 212 Record Memory Dump 213 214 0000000058EDA08D: 01034211 8b787878 40 ..B..xxx@ 215 216 Slot 5 Column 1 Offset 0x4 Length 4 Length (physical) 1 217 218 id = 11 219 220 Slot 5 Column 2 Offset 0x5 Length 999 Length (physical) 3 221 222 col2 = xxx 223 224 225 226 227 228 229 230 231 232 Slot 5 Column 3 Offset 0x0 Length 0 Length (physical) 0 233 234 col3 = 235 236 Slot 6 Offset 0x96 Length 9 237 238 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 239 240 CD Array 241 242 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 243 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 244 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 245 Record Memory Dump 246 247 0000000058EDA096: 01034211 8d787878 40 ..B..xxx@ 248 249 Slot 6 Column 1 Offset 0x4 Length 4 Length (physical) 1 250 251 id = 13 252 253 Slot 6 Column 2 Offset 0x5 Length 999 Length (physical) 3 254 255 col2 = xxx 256 257 258 259 260 261 262 263 264 265 Slot 6 Column 3 Offset 0x0 Length 0 Length (physical) 0 266 267 col3 = 268 269 Slot 7 Offset 0x9f Length 9 270 271 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 272 273 CD Array 274 275 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 276 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 277 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 278 Record Memory Dump 279 280 0000000058EDA09F: 01034211 8f787878 40 ..B..xxx@ 281 282 Slot 7 Column 1 Offset 0x4 Length 4 Length (physical) 1 283 284 id = 15 285 286 Slot 7 Column 2 Offset 0x5 Length 999 Length (physical) 3 287 288 col2 = xxx 289 290 291 292 293 294 295 296 297 298 Slot 7 Column 3 Offset 0x0 Length 0 Length (physical) 0 299 300 col3 = 301 302 Slot 8 Offset 0xa8 Length 9 303 304 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 305 306 CD Array 307 308 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 309 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 310 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 311 Record Memory Dump 312 313 0000000058EDA0A8: 01034211 91787878 40 ..B..xxx@ 314 315 Slot 8 Column 1 Offset 0x4 Length 4 Length (physical) 1 316 317 id = 17 318 319 Slot 8 Column 2 Offset 0x5 Length 999 Length (physical) 3 320 321 col2 = xxx 322 323 324 325 326 327 328 329 330 331 Slot 8 Column 3 Offset 0x0 Length 0 Length (physical) 0 332 333 col3 = 334 335 Slot 9 Offset 0xb1 Length 9 336 337 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 338 339 CD Array 340 341 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 342 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 343 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 344 Record Memory Dump 345 346 0000000058EDA0B1: 01034211 93787878 40 ..B..xxx@ 347 348 Slot 9 Column 1 Offset 0x4 Length 4 Length (physical) 1 349 350 id = 19 351 352 Slot 9 Column 2 Offset 0x5 Length 999 Length (physical) 3 353 354 col2 = xxx 355 356 357 358 359 360 361 362 363 364 Slot 9 Column 3 Offset 0x0 Length 0 Length (physical) 0 365 366 col3 = 367 368 Slot 10 Offset 0xba Length 9 369 370 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 371 372 CD Array 373 374 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 375 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 376 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 377 Record Memory Dump 378 379 0000000058EDA0BA: 01034211 95787878 40 ..B..xxx@ 380 381 Slot 10 Column 1 Offset 0x4 Length 4 Length (physical) 1 382 383 id = 21 384 385 Slot 10 Column 2 Offset 0x5 Length 999 Length (physical) 3 386 387 col2 = xxx 388 389 390 391 392 393 394 395 396 397 Slot 10 Column 3 Offset 0x0 Length 0 Length (physical) 0 398 399 col3 = 400 401 Slot 11 Offset 0xc3 Length 9 402 403 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 404 405 CD Array 406 407 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 408 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 409 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 410 Record Memory Dump 411 412 0000000058EDA0C3: 01034211 97787878 40 ..B..xxx@ 413 414 Slot 11 Column 1 Offset 0x4 Length 4 Length (physical) 1 415 416 id = 23 417 418 Slot 11 Column 2 Offset 0x5 Length 999 Length (physical) 3 419 420 col2 = xxx 421 422 423 424 425 426 427 428 429 430 Slot 11 Column 3 Offset 0x0 Length 0 Length (physical) 0 431 432 col3 = 433 434 Slot 12 Offset 0xcc Length 9 435 436 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 437 438 CD Array 439 440 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 441 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 442 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 443 Record Memory Dump 444 445 0000000058EDA0CC: 01034211 99787878 40 ..B..xxx@ 446 447 Slot 12 Column 1 Offset 0x4 Length 4 Length (physical) 1 448 449 id = 25 450 451 Slot 12 Column 2 Offset 0x5 Length 999 Length (physical) 3 452 453 col2 = xxx 454 455 456 457 458 459 460 461 462 463 Slot 12 Column 3 Offset 0x0 Length 0 Length (physical) 0 464 465 col3 = 466 467 Slot 13 Offset 0xd5 Length 9 468 469 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 470 471 CD Array 472 473 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 474 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 475 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 476 Record Memory Dump 477 478 0000000058EDA0D5: 01034211 9b787878 40 ..B..xxx@ 479 480 Slot 13 Column 1 Offset 0x4 Length 4 Length (physical) 1 481 482 id = 27 483 484 Slot 13 Column 2 Offset 0x5 Length 999 Length (physical) 3 485 486 col2 = xxx 487 488 489 490 491 492 493 494 495 496 Slot 13 Column 3 Offset 0x0 Length 0 Length (physical) 0 497 498 col3 = 499 500 Slot 14 Offset 0xde Length 9 501 502 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 503 504 CD Array 505 506 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 507 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 508 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 509 Record Memory Dump 510 511 0000000058EDA0DE: 01034211 9d787878 40 ..B..xxx@ 512 513 Slot 14 Column 1 Offset 0x4 Length 4 Length (physical) 1 514 515 id = 29 516 517 Slot 14 Column 2 Offset 0x5 Length 999 Length (physical) 3 518 519 col2 = xxx 520 521 522 523 524 525 526 527 528 529 Slot 14 Column 3 Offset 0x0 Length 0 Length (physical) 0 530 531 col3 = 532 533 Slot 15 Offset 0xe7 Length 9 534 535 Record Type = (COMPRESSED) PRIMARY_RECORD Record size = 9 536 537 CD Array 538 539 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x02 (ONE_BYTE_SHORT) 540 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 541 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x01 (EMPTY) 542 Record Memory Dump 543 544 0000000058EDA0E7: 01034211 9f787878 40 ..B..xxx@ 545 546 Slot 15 Column 1 Offset 0x4 Length 4 Length (physical) 1 547 548 id = 31 549 550 Slot 15 Column 2 Offset 0x5 Length 999 Length (physical) 3 551 552 col2 = xxx 553 554 555 556 557 558 559 560 561 562 Slot 15 Column 3 Offset 0x0 Length 0 Length (physical) 0 563 564 col3 = 565 566 567 DBCC 执行完毕。如果 DBCC 输出了错误信息，请与系统管理员联系。
创建聚集索引，看聚集索引是否压缩
1 CREATE CLUSTERED INDEX cix_ClusteredTable ON ClusteredTable([ID] ASC)
1 --TRUNCATE TABLE [dbo].[DBCCResult] 2 INSERT INTO DBCCResult EXEC ('DBCC IND(pratice,ClusteredTable,-1) ') 3 4 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC
插入更多数据
1 DECLARE @i INT 2 SET @i=1 3 WHILE(@i<100000) 4 BEGIN 5 INSERT INTO [dbo].[ClusteredTable] ( [id], [col2], [col3] ) 6 VALUES(@i,'xxx','') 7 SET @i=@i+2 8 END
1 DBCC TRACEON(3604,-1) 2 GO 3 DBCC PAGE([pratice],1,13955,1) 4 GO
1 DBCC 执行完毕。如果 DBCC 输出了错误信息，请与系统管理员联系。 2 3 PAGE: (1:13955) 4 5 6 BUFFER: 7 8 9 BUF @0x0000000004CA3A80 10 11 bpage = 0x00000001AFF74000 bhash = 0x0000000000000000 bpageno = (1:13955) 12 bdbid = 8 breferences = 0 bcputicks = 0 13 bsampleCount = 0 bUse1 = 2591 bstat = 0xb 14 blog = 0x2121cc7a bnext = 0x0000000000000000 15 16 PAGE HEADER: 17 18 19 Page @0x00000001AFF74000 20 21 m_pageId = (1:13955) m_headerVersion = 1 m_type = 2 22 m_typeFlagBits = 0x0 m_level = 1 m_flagBits = 0x8000 23 m_objId (AllocUnitId.idObj) = 261 m_indexId (AllocUnitId.idInd) = 256 24 Metadata: AllocUnitId = 72057594055032832 25 Metadata: PartitionId = 72057594047299584 Metadata: IndexId = 1 26 Metadata: ObjectId = 1058102810 m_prevPage = (0:0) m_nextPage = (0:0) 27 pminlen = 10 m_slotCnt = 69 m_freeCnt = 7086 28 m_freeData = 968 m_reservedCnt = 0 m_lsn = (2564:585:15) 29 m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0 30 m_tornBits = 346707009 DB Frag ID = 1 31 32 Allocation Status 33 34 GAM (1:2) = ALLOCATED SGAM (1:3) = ALLOCATED 35 PFS (1:8088) = 0x60 MIXED_EXT ALLOCATED 0_PCT_FULL DIFF (1:6) = CHANGED 36 ML (1:7) = NOT MIN_LOGGED 37 38 DATA: 39 40 41 Slot 0, Offset 0x60, Length 10, DumpStyle BYTE 42 43 Record Type = (COMPRESSED) INDEX_RECORD Record size = 10 44 45 CD Array 46 47 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x01 (EMPTY) 48 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 49 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 50 51 Record Memory Dump 52 53 000000005A9DA060: 19031117 7e360000 0100 ....~6.... 54 55 Slot 1, Offset 0x6a, Length 12, DumpStyle BYTE 56 57 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 58 59 CD Array 60 61 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 62 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 63 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 64 65 Record Memory Dump 66 67 000000005A9DA06A: 19031317 85a18436 00000100 .......6.... 68 69 Slot 2, Offset 0x76, Length 12, DumpStyle BYTE 70 71 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 72 73 CD Array 74 75 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 76 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 77 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 78 79 Record Memory Dump 80 81 000000005A9DA076: 19031317 8b618536 00000100 .....a.6.... 82 83 Slot 3, Offset 0x82, Length 12, DumpStyle BYTE 84 85 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 86 87 CD Array 88 89 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 90 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 91 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 92 93 Record Memory Dump 94 95 000000005A9DA082: 19031317 91218636 00000100 .....!.6.... 96 97 Slot 4, Offset 0x8e, Length 12, DumpStyle BYTE 98 99 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 100 101 CD Array 102 103 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 104 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 105 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 106 107 Record Memory Dump 108 109 000000005A9DA08E: 19031317 96e18736 00000100 .......6.... 110 111 Slot 5, Offset 0x9a, Length 12, DumpStyle BYTE 112 113 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 114 115 CD Array 116 117 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 118 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 119 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 120 121 Record Memory Dump 122 123 000000005A9DA09A: 19031317 9ca12736 00000100 ......'6.... 124 125 Slot 6, Offset 0xa6, Length 12, DumpStyle BYTE 126 127 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 128 129 CD Array 130 131 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 132 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 133 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 134 135 Record Memory Dump 136 137 000000005A9DA0A6: 19031317 a2617936 00000100 .....ay6.... 138 139 Slot 7, Offset 0xb2, Length 12, DumpStyle BYTE 140 141 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 142 143 CD Array 144 145 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 146 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 147 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 148 149 Record Memory Dump 150 151 000000005A9DA0B2: 19031317 a8217802 00000100 .....!x..... 152 153 Slot 8, Offset 0xbe, Length 12, DumpStyle BYTE 154 155 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 156 157 CD Array 158 159 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 160 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 161 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 162 163 Record Memory Dump 164 165 000000005A9DA0BE: 19031317 ade17902 00000100 ......y..... 166 167 Slot 9, Offset 0xca, Length 12, DumpStyle BYTE 168 169 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 170 171 CD Array 172 173 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 174 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 175 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 176 177 Record Memory Dump 178 179 000000005A9DA0CA: 19031317 b3a17a02 00000100 ......z..... 180 181 Slot 10, Offset 0xd6, Length 12, DumpStyle BYTE 182 183 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 184 185 CD Array 186 187 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 188 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 189 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 190 191 Record Memory Dump 192 193 000000005A9DA0D6: 19031317 b9617b02 00000100 .....a{..... 194 195 Slot 11, Offset 0xe2, Length 12, DumpStyle BYTE 196 197 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 198 199 CD Array 200 201 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 202 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 203 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 204 205 Record Memory Dump 206 207 000000005A9DA0E2: 19031317 bf217c02 00000100 .....!|..... 208 209 Slot 12, Offset 0xee, Length 12, DumpStyle BYTE 210 211 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 212 213 CD Array 214 215 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 216 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 217 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 218 219 Record Memory Dump 220 221 000000005A9DA0EE: 19031317 c4e17d02 00000100 ......}..... 222 223 Slot 13, Offset 0xfa, Length 12, DumpStyle BYTE 224 225 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 226 227 CD Array 228 229 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 230 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 231 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 232 233 Record Memory Dump 234 235 000000005A9DA0FA: 19031317 caa17e02 00000100 ......~..... 236 237 Slot 14, Offset 0x106, Length 12, DumpStyle BYTE 238 239 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 240 241 CD Array 242 243 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 244 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 245 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 246 247 Record Memory Dump 248 249 000000005A9DA106: 19031317 d0617f02 00000100 .....a...... 250 251 Slot 15, Offset 0x112, Length 12, DumpStyle BYTE 252 253 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 254 255 CD Array 256 257 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 258 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 259 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 260 261 Record Memory Dump 262 263 000000005A9DA112: 19031317 d6218002 00000100 .....!...... 264 265 Slot 16, Offset 0x11e, Length 12, DumpStyle BYTE 266 267 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 268 269 CD Array 270 271 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 272 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 273 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 274 275 Record Memory Dump 276 277 000000005A9DA11E: 19031317 dbe18102 00000100 ............ 278 279 Slot 17, Offset 0x12a, Length 12, DumpStyle BYTE 280 281 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 282 283 CD Array 284 285 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 286 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 287 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 288 289 Record Memory Dump 290 291 000000005A9DA12A: 19031317 e1a18202 00000100 ............ 292 293 Slot 18, Offset 0x136, Length 12, DumpStyle BYTE 294 295 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 296 297 CD Array 298 299 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 300 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 301 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 302 303 Record Memory Dump 304 305 000000005A9DA136: 19031317 e7618302 00000100 .....a...... 306 307 Slot 19, Offset 0x142, Length 12, DumpStyle BYTE 308 309 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 310 311 CD Array 312 313 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 314 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 315 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 316 317 Record Memory Dump 318 319 000000005A9DA142: 19031317 ed218402 00000100 .....!...... 320 321 Slot 20, Offset 0x14e, Length 12, DumpStyle BYTE 322 323 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 324 325 CD Array 326 327 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 328 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 329 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 330 331 Record Memory Dump 332 333 000000005A9DA14E: 19031317 f2e18502 00000100 ............ 334 335 Slot 21, Offset 0x15a, Length 12, DumpStyle BYTE 336 337 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 338 339 CD Array 340 341 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 342 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 343 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 344 345 Record Memory Dump 346 347 000000005A9DA15A: 19031317 f8a18602 00000100 ............ 348 349 Slot 22, Offset 0x166, Length 12, DumpStyle BYTE 350 351 Record Type = (COMPRESSED) INDEX_RECORD Record size = 12 352 353 CD Array 354 355 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x03 (TWO_BYTE_SHORT) 356 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 357 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 358 359 Record Memory Dump 360 361 000000005A9DA166: 19031317 fe618702 00000100 .....a...... 362 363 Slot 23, Offset 0x172, Length 13, DumpStyle BYTE 364 365 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 366 367 CD Array 368 369 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 370 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 371 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 372 373 Record Memory Dump 374 375 000000005A9DA172: 19031417 80841d88 02000001 00 ............. 376 377 Slot 24, Offset 0x17f, Length 13, DumpStyle BYTE 378 379 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 380 381 CD Array 382 383 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 384 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 385 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 386 387 Record Memory Dump 388 389 000000005A9DA17F: 19031417 8089d989 02000001 00 ............. 390 391 Slot 25, Offset 0x18c, Length 13, DumpStyle BYTE 392 393 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 394 395 CD Array 396 397 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 398 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 399 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 400 401 Record Memory Dump 402 403 000000005A9DA18C: 19031417 808f958a 02000001 00 ............. 404 405 Slot 26, Offset 0x199, Length 13, DumpStyle BYTE 406 407 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 408 409 CD Array 410 411 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 412 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 413 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 414 415 Record Memory Dump 416 417 000000005A9DA199: 19031417 8095518b 02000001 00 ......Q...... 418 419 Slot 27, Offset 0x1a6, Length 13, DumpStyle BYTE 420 421 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 422 423 CD Array 424 425 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 426 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 427 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 428 429 Record Memory Dump 430 431 000000005A9DA1A6: 19031417 809b0d8c 02000001 00 ............. 432 433 Slot 28, Offset 0x1b3, Length 13, DumpStyle BYTE 434 435 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 436 437 CD Array 438 439 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 440 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 441 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 442 443 Record Memory Dump 444 445 000000005A9DA1B3: 19031417 80a0c98d 02000001 00 ............. 446 447 Slot 29, Offset 0x1c0, Length 13, DumpStyle BYTE 448 449 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 450 451 CD Array 452 453 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 454 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 455 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 456 457 Record Memory Dump 458 459 000000005A9DA1C0: 19031417 80a6858e 02000001 00 ............. 460 461 Slot 30, Offset 0x1cd, Length 13, DumpStyle BYTE 462 463 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 464 465 CD Array 466 467 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 468 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 469 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 470 471 Record Memory Dump 472 473 000000005A9DA1CD: 19031417 80ac418f 02000001 00 ......A...... 474 475 Slot 31, Offset 0x1da, Length 13, DumpStyle BYTE 476 477 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 478 479 CD Array 480 481 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 482 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 483 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 484 485 Record Memory Dump 486 487 000000005A9DA1DA: 19031417 80b1fd90 02000001 00 ............. 488 489 Slot 32, Offset 0x1e7, Length 13, DumpStyle BYTE 490 491 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 492 493 CD Array 494 495 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 496 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 497 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 498 499 Record Memory Dump 500 501 000000005A9DA1E7: 19031417 80b7b991 02000001 00 ............. 502 503 Slot 33, Offset 0x1f4, Length 13, DumpStyle BYTE 504 505 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 506 507 CD Array 508 509 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 510 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 511 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 512 513 Record Memory Dump 514 515 000000005A9DA1F4: 19031417 80bd7592 02000001 00 ......u...... 516 517 Slot 34, Offset 0x201, Length 13, DumpStyle BYTE 518 519 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 520 521 CD Array 522 523 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 524 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 525 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 526 527 Record Memory Dump 528 529 000000005A9DA201: 19031417 80c33193 02000001 00 ......1...... 530 531 Slot 35, Offset 0x20e, Length 13, DumpStyle BYTE 532 533 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 534 535 CD Array 536 537 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 538 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 539 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 540 541 Record Memory Dump 542 543 000000005A9DA20E: 19031417 80c8ed94 02000001 00 ............. 544 545 Slot 36, Offset 0x21b, Length 13, DumpStyle BYTE 546 547 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 548 549 CD Array 550 551 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 552 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 553 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 554 555 Record Memory Dump 556 557 000000005A9DA21B: 19031417 80cea995 02000001 00 ............. 558 559 Slot 37, Offset 0x228, Length 13, DumpStyle BYTE 560 561 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 562 563 CD Array 564 565 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 566 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 567 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 568 569 Record Memory Dump 570 571 000000005A9DA228: 19031417 80d46596 02000001 00 ......e...... 572 573 Slot 38, Offset 0x235, Length 13, DumpStyle BYTE 574 575 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 576 577 CD Array 578 579 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 580 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 581 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 582 583 Record Memory Dump 584 585 000000005A9DA235: 19031417 80da2197 02000001 00 ......!...... 586 587 Slot 39, Offset 0x242, Length 13, DumpStyle BYTE 588 589 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 590 591 CD Array 592 593 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 594 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 595 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 596 597 Record Memory Dump 598 599 000000005A9DA242: 19031417 80dfdd98 02000001 00 ............. 600 601 Slot 40, Offset 0x24f, Length 13, DumpStyle BYTE 602 603 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 604 605 CD Array 606 607 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 608 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 609 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 610 611 Record Memory Dump 612 613 000000005A9DA24F: 19031417 80e59999 02000001 00 ............. 614 615 Slot 41, Offset 0x25c, Length 13, DumpStyle BYTE 616 617 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 618 619 CD Array 620 621 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 622 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 623 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 624 625 Record Memory Dump 626 627 000000005A9DA25C: 19031417 80eb559a 02000001 00 ......U...... 628 629 Slot 42, Offset 0x269, Length 13, DumpStyle BYTE 630 631 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 632 633 CD Array 634 635 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 636 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 637 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 638 639 Record Memory Dump 640 641 000000005A9DA269: 19031417 80f1119b 02000001 00 ............. 642 643 Slot 43, Offset 0x276, Length 13, DumpStyle BYTE 644 645 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 646 647 CD Array 648 649 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 650 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 651 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 652 653 Record Memory Dump 654 655 000000005A9DA276: 19031417 80f6cd9c 02000001 00 ............. 656 657 Slot 44, Offset 0x283, Length 13, DumpStyle BYTE 658 659 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 660 661 CD Array 662 663 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 664 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 665 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 666 667 Record Memory Dump 668 669 000000005A9DA283: 19031417 80fc899d 02000001 00 ............. 670 671 Slot 45, Offset 0x290, Length 13, DumpStyle BYTE 672 673 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 674 675 CD Array 676 677 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 678 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 679 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 680 681 Record Memory Dump 682 683 000000005A9DA290: 19031417 8102459e 02000001 00 ......E...... 684 685 Slot 46, Offset 0x29d, Length 13, DumpStyle BYTE 686 687 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 688 689 CD Array 690 691 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 692 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 693 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 694 695 Record Memory Dump 696 697 000000005A9DA29D: 19031417 8108019f 02000001 00 ............. 698 699 Slot 47, Offset 0x2aa, Length 13, DumpStyle BYTE 700 701 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 702 703 CD Array 704 705 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 706 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 707 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 708 709 Record Memory Dump 710 711 000000005A9DA2AA: 19031417 810dbda0 02000001 00 ............. 712 713 Slot 48, Offset 0x2b7, Length 13, DumpStyle BYTE 714 715 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 716 717 CD Array 718 719 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 720 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 721 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 722 723 Record Memory Dump 724 725 000000005A9DA2B7: 19031417 811379a1 02000001 00 ......y...... 726 727 Slot 49, Offset 0x2c4, Length 13, DumpStyle BYTE 728 729 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 730 731 CD Array 732 733 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 734 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 735 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 736 737 Record Memory Dump 738 739 000000005A9DA2C4: 19031417 811935a2 02000001 00 ......5...... 740 741 Slot 50, Offset 0x2d1, Length 13, DumpStyle BYTE 742 743 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 744 745 CD Array 746 747 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 748 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 749 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 750 751 Record Memory Dump 752 753 000000005A9DA2D1: 19031417 811ef1a3 02000001 00 ............. 754 755 Slot 51, Offset 0x2de, Length 13, DumpStyle BYTE 756 757 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 758 759 CD Array 760 761 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 762 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 763 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 764 765 Record Memory Dump 766 767 000000005A9DA2DE: 19031417 8124ada4 02000001 00 .....$....... 768 769 Slot 52, Offset 0x2eb, Length 13, DumpStyle BYTE 770 771 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 772 773 CD Array 774 775 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 776 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 777 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 778 779 Record Memory Dump 780 781 000000005A9DA2EB: 19031417 812a69a5 02000001 00 .....*i...... 782 783 Slot 53, Offset 0x2f8, Length 13, DumpStyle BYTE 784 785 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 786 787 CD Array 788 789 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 790 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 791 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 792 793 Record Memory Dump 794 795 000000005A9DA2F8: 19031417 813025a6 02000001 00 .....0%...... 796 797 Slot 54, Offset 0x305, Length 13, DumpStyle BYTE 798 799 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 800 801 CD Array 802 803 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 804 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 805 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 806 807 Record Memory Dump 808 809 000000005A9DA305: 19031417 8135e1a7 02000001 00 .....5....... 810 811 Slot 55, Offset 0x312, Length 13, DumpStyle BYTE 812 813 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 814 815 CD Array 816 817 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 818 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 819 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 820 821 Record Memory Dump 822 823 000000005A9DA312: 19031417 813b9da8 02000001 00 .....;....... 824 825 Slot 56, Offset 0x31f, Length 13, DumpStyle BYTE 826 827 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 828 829 CD Array 830 831 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 832 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 833 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 834 835 Record Memory Dump 836 837 000000005A9DA31F: 19031417 814159a9 02000001 00 .....AY...... 838 839 Slot 57, Offset 0x32c, Length 13, DumpStyle BYTE 840 841 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 842 843 CD Array 844 845 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 846 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 847 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 848 849 Record Memory Dump 850 851 000000005A9DA32C: 19031417 814715aa 02000001 00 .....G....... 852 853 Slot 58, Offset 0x339, Length 13, DumpStyle BYTE 854 855 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 856 857 CD Array 858 859 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 860 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 861 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 862 863 Record Memory Dump 864 865 000000005A9DA339: 19031417 814cd1ab 02000001 00 .....L....... 866 867 Slot 59, Offset 0x346, Length 13, DumpStyle BYTE 868 869 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 870 871 CD Array 872 873 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 874 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 875 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 876 877 Record Memory Dump 878 879 000000005A9DA346: 19031417 81528dac 02000001 00 .....R....... 880 881 Slot 60, Offset 0x353, Length 13, DumpStyle BYTE 882 883 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 884 885 CD Array 886 887 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 888 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 889 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 890 891 Record Memory Dump 892 893 000000005A9DA353: 19031417 815849ad 02000001 00 .....XI...... 894 895 Slot 61, Offset 0x360, Length 13, DumpStyle BYTE 896 897 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 898 899 CD Array 900 901 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 902 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 903 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 904 905 Record Memory Dump 906 907 000000005A9DA360: 19031417 815e05ae 02000001 00 .....^....... 908 909 Slot 62, Offset 0x36d, Length 13, DumpStyle BYTE 910 911 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 912 913 CD Array 914 915 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 916 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 917 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 918 919 Record Memory Dump 920 921 000000005A9DA36D: 19031417 8163c1af 02000001 00 .....c....... 922 923 Slot 63, Offset 0x37a, Length 13, DumpStyle BYTE 924 925 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 926 927 CD Array 928 929 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 930 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 931 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 932 933 Record Memory Dump 934 935 000000005A9DA37A: 19031417 81697db0 02000001 00 .....i}...... 936 937 Slot 64, Offset 0x387, Length 13, DumpStyle BYTE 938 939 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 940 941 CD Array 942 943 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 944 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 945 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 946 947 Record Memory Dump 948 949 000000005A9DA387: 19031417 816f39b1 02000001 00 .....o9...... 950 951 Slot 65, Offset 0x394, Length 13, DumpStyle BYTE 952 953 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 954 955 CD Array 956 957 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 958 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 959 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 960 961 Record Memory Dump 962 963 000000005A9DA394: 19031417 8174f5b2 02000001 00 .....t....... 964 965 Slot 66, Offset 0x3a1, Length 13, DumpStyle BYTE 966 967 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 968 969 CD Array 970 971 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 972 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 973 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 974 975 Record Memory Dump 976 977 000000005A9DA3A1: 19031417 817ab1b3 02000001 00 .....z....... 978 979 Slot 67, Offset 0x3ae, Length 13, DumpStyle BYTE 980 981 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 982 983 CD Array 984 985 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 986 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 987 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 988 989 Record Memory Dump 990 991 000000005A9DA3AE: 19031417 81806db4 02000001 00 ......m...... 992 993 Slot 68, Offset 0x3bb, Length 13, DumpStyle BYTE 994 995 Record Type = (COMPRESSED) INDEX_RECORD Record size = 13 996 997 CD Array 998 999 CD array entry = Column 1 (cluster 0, CD array offset 0): 0x04 (THREE_BYTE_SHORT) 1000 CD array entry = Column 2 (cluster 0, CD array offset 0): 0x01 (EMPTY) 1001 CD array entry = Column 3 (cluster 0, CD array offset 1): 0x07 (SIX_BYTE_SHORT) 1002 1003 Record Memory Dump 1004 1005 000000005A9DA3BB: 19031417 818629b5 02000001 00 ......)...... 1006 1007 OFFSET TABLE: 1008 1009 Row - Offset 1010 68 (0x44) - 955 (0x3bb) 1011 67 (0x43) - 942 (0x3ae) 1012 66 (0x42) - 929 (0x3a1) 1013 65 (0x41) - 916 (0x394) 1014 64 (0x40) - 903 (0x387) 1015 63 (0x3f) - 890 (0x37a) 1016 62 (0x3e) - 877 (0x36d) 1017 61 (0x3d) - 864 (0x360) 1018 60 (0x3c) - 851 (0x353) 1019 59 (0x3b) - 838 (0x346) 1020 58 (0x3a) - 825 (0x339) 1021 57 (0x39) - 812 (0x32c) 1022 56 (0x38) - 799 (0x31f) 1023 55 (0x37) - 786 (0x312) 1024 54 (0x36) - 773 (0x305) 1025 53 (0x35) - 760 (0x2f8) 1026 52 (0x34) - 747 (0x2eb) 1027 51 (0x33) - 734 (0x2de) 1028 50 (0x32) - 721 (0x2d1) 1029 49 (0x31) - 708 (0x2c4) 1030 48 (0x30) - 695 (0x2b7) 1031 47 (0x2f) - 682 (0x2aa) 1032 46 (0x2e) - 669 (0x29d) 1033 45 (0x2d) - 656 (0x290) 1034 44 (0x2c) - 643 (0x283) 1035 43 (0x2b) - 630 (0x276) 1036 42 (0x2a) - 617 (0x269) 1037 41 (0x29) - 604 (0x25c) 1038 40 (0x28) - 591 (0x24f) 1039 39 (0x27) - 578 (0x242) 1040 38 (0x26) - 565 (0x235) 1041 37 (0x25) - 552 (0x228) 1042 36 (0x24) - 539 (0x21b) 1043 35 (0x23) - 526 (0x20e) 1044 34 (0x22) - 513 (0x201) 1045 33 (0x21) - 500 (0x1f4) 1046 32 (0x20) - 487 (0x1e7) 1047 31 (0x1f) - 474 (0x1da) 1048 30 (0x1e) - 461 (0x1cd) 1049 29 (0x1d) - 448 (0x1c0) 1050 28 (0x1c) - 435 (0x1b3) 1051 27 (0x1b) - 422 (0x1a6) 1052 26 (0x1a) - 409 (0x199) 1053 25 (0x19) - 396 (0x18c) 1054 24 (0x18) - 383 (0x17f) 1055 23 (0x17) - 370 (0x172) 1056 22 (0x16) - 358 (0x166) 1057 21 (0x15) - 346 (0x15a) 1058 20 (0x14) - 334 (0x14e) 1059 19 (0x13) - 322 (0x142) 1060 18 (0x12) - 310 (0x136) 1061 17 (0x11) - 298 (0x12a) 1062 16 (0x10) - 286 (0x11e) 1063 15 (0xf) - 274 (0x112) 1064 14 (0xe) - 262 (0x106) 1065 13 (0xd) - 250 (0xfa) 1066 12 (0xc) - 238 (0xee) 1067 11 (0xb) - 226 (0xe2) 1068 10 (0xa) - 214 (0xd6) 1069 9 (0x9) - 202 (0xca) 1070 8 (0x8) - 190 (0xbe) 1071 7 (0x7) - 178 (0xb2) 1072 6 (0x6) - 166 (0xa6) 1073 5 (0x5) - 154 (0x9a) 1074 4 (0x4) - 142 (0x8e) 1075 3 (0x3) - 130 (0x82) 1076 2 (0x2) - 118 (0x76) 1077 1 (0x1) - 106 (0x6a) 1078 0 (0x0) - 96 (0x60) 1079 1080 1081 DBCC 执行完毕。如果 DBCC 输出了错误信息，请与系统管理员联系。
1 DBCC TRACEON(3604,-1) 2 GO 3 DBCC PAGE([pratice],1,13955,3) 4 GO
页面压缩和行压缩比较
1 --行压缩 2 USE [pratice] 3 GO 4 CREATE TABLE ClusteredTablerow 5 ( id INT, 6 col2 CHAR(999), 7 col3 VARCHAR(10) 8 )WITH (DATA_COMPRESSION = ROW) 9 10 11 DECLARE @i INT 12 SET @i=1 13 WHILE(@i<12) 14 BEGIN 15 INSERT INTO [dbo].[ClusteredTablerow] ( [id], [col2], [col3] ) 16 VALUES(@i,'xxx','') 17 SET @i=@i+2 18 END 19 20 SELECT * FROM ClusteredTablerow 21 22 23 24 --TRUNCATE TABLE [dbo].[DBCCResult] 25 INSERT INTO DBCCResult EXEC ('DBCC IND(pratice,ClusteredTablerow,-1) ') 26 27 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC 28 29 DBCC TRACEON(3604,-1) 30 GO 31 DBCC PAGE([pratice],1,13956,3) 32 GO
1 --页面压缩 2 USE [pratice] 3 GO 4 CREATE TABLE ClusteredTable 5 ( id INT, 6 col2 CHAR(999), 7 col3 VARCHAR(10) 8 )WITH (DATA_COMPRESSION = PAGE) 9 10 11 DECLARE @i INT 12 SET @i=1 13 WHILE(@i<12) 14 BEGIN 15 INSERT INTO [dbo].[ClusteredTable] ( [id], [col2], [col3] ) 16 VALUES(@i,'xxx','') 17 SET @i=@i+2 18 END 19 20 SELECT * FROM ClusteredTable 21 22 23 24 --TRUNCATE TABLE [dbo].[DBCCResult] 25 INSERT INTO DBCCResult EXEC ('DBCC IND(pratice,ClusteredTable,-1) ') 26 27 SELECT * FROM [dbo].[DBCCResult] ORDER BY [PageType] DESC 28 29 DBCC TRACEON(3604,-1) 30 GO 31 DBCC PAGE([pratice],1,13952,3) 32 GO
我们用beyond compare这个工具来比较不同点
