溫馨提示×
您好，登錄后才能下訂單哦！
點(diǎn)擊 登錄注冊 即表示同意《億速云用戶服務(wù)條款》
您好，登錄后才能下訂單哦！
這篇文章主要為大家展示了“sql server 2005數(shù)據(jù)修改的示例分析”，內(nèi)容簡而易懂，條理清晰，希望能夠幫助大家解決疑惑，下面讓小編帶領(lǐng)大家一起研究并學(xué)習(xí)一下“sql server 2005數(shù)據(jù)修改的示例分析”這篇文章吧。
當(dāng)插入新的記錄到數(shù)據(jù)表中時(shí)，SQL Server必須決定在哪里插入記錄。如果數(shù)據(jù)表沒有聚集索引---也就是說，數(shù)據(jù)表還是堆表的話--新的記錄總是插到表中任何有可用空間的地方。如果空間中沒有可用的分頁，SQL Server會嘗試從已經(jīng)分配給對象的現(xiàn)有的統(tǒng)一擴(kuò)展中尋找未分配的分頁。如果這樣的分頁也不存在，SQL Server就必須為數(shù)據(jù)表分配一個(gè)全新的擴(kuò)展。
聚集索引根據(jù)新記錄的聚集索引鍵列的值將插入導(dǎo)向到特定的分頁。當(dāng)新的記錄是插入語句的直接結(jié)果或者是由“刪除+插入”策略所執(zhí)行的更新語句的結(jié)果時(shí)就會發(fā)生插入。SQL Server將新的記錄插入到聚集索引中的合適位置，如果當(dāng)前分頁沒有可用空間的話，會通過頁拆分(page split)在分頁中進(jìn)行接合。如果不將聚集索引 聲明為唯一性并插入具有重復(fù)鍵值的記錄時(shí)，SQL Server會為所有后續(xù)的具有相同鍵值的記錄自動(dòng)生成一個(gè)唯一標(biāo)識符(uniqueifier)。于是，SQL Server在內(nèi)部將所有的聚集索引鍵都看作是唯一的。
頁拆分(Splitting Pages)
SQL Server找到新的可用分頁以后，原來的分頁就要被拆分：行的一半留在原來的分頁上，而另一半則被移到新的分頁上。在某些情況下，由于變長字段的長度可能會變得遠(yuǎn)遠(yuǎn)大于分頁上任何現(xiàn)有的記錄，SQL Server會發(fā)現(xiàn)即使在頁拆分以后仍然沒有可用空間來存放新的記錄。拆分后，一條或多條記錄會被提升到父級分頁中。如果只需要一次拆分，那么就提升一條記錄。然而，如果在一次拆分后仍然無法容納新的記錄，那么就可能會潛在地產(chǎn)生多個(gè)新的分頁并產(chǎn)生多次到父級分頁的提升。舉例來說，比如一個(gè)具有32行數(shù)據(jù)的分頁。假設(shè)SQL Server嘗試插入一條8000個(gè)字節(jié)長的新記錄。SQL Server會對該分頁進(jìn)行一次拆分，但是無法丙容納一條800個(gè)字節(jié)長的新記錄。即使在第二次拆分后，仍然無法容納新的記錄。最終，SQL Server會意識到如果分頁中有任何其他記錄存在的話是無法容納這條新記錄的，因此它會分配一個(gè)新的分頁來容納這條唯一的新記錄。于是，會發(fā)生幾次頁拆分，產(chǎn)生許多新的分頁以及父級分頁中的許多新的行。
SQL Server總是從根節(jié)點(diǎn)向下搜索索引樹的，因此在插入操作的過程中，分頁是在下層中進(jìn)行的。這意味著當(dāng)插入操作搜索索引的時(shí)候，需要將索引保護(hù)起來防止可能的更新操作。這種保護(hù)機(jī)制使用閂鎖。當(dāng)分頁被讀取或者被寫入磁盤的時(shí)候，SQL Server會獲取閂鎖來保護(hù)分頁內(nèi)容的物理完整性。父節(jié)點(diǎn)(非葉節(jié)點(diǎn))被閂鎖鎖住直到得知子節(jié)點(diǎn)擁有自己的閂鎖來保護(hù)時(shí)為止。然后，父級的閂鎖就可以安全地被釋放掉了。
在父級節(jié)點(diǎn)上的閂鎖被釋放以前，SQL Server會判斷分頁是否能夠容納另兩行數(shù)據(jù)。如果不能的話，就進(jìn)行頁拆分。最終目的是確保父級分頁總是有足夠的空間容納記錄或者由子分頁拆分所得到的記錄(有時(shí)候這會導(dǎo)致無需進(jìn)行頁拆分--至少尚未拆分。這將帶來性能上的優(yōu)化）。拆分的類型取決于被拆分分頁的類型：索引的根分頁，中間級的索引分頁以及數(shù)據(jù)分頁。
拆分索引的根分頁
如果索引的根分頁需要為插入一條新的索引也被拆分的話，SQL Server會為此索引分配兩個(gè)新的分頁。根分頁中的所有記錄在這兩個(gè)新分頁中被拆分，而新的索引行也被插入到這些分頁之中的某個(gè)合適的位置。原來的根分頁仍然是根，但是現(xiàn)在上面只有兩條記錄，指向新分配的兩個(gè)分頁。根的頁拆分會在索引中創(chuàng)建一個(gè)新的級別。由于索引通常只有幾層的深度，這種類型的拆分并不會經(jīng)常發(fā)生。
拆分中間級索引分頁
中間級索引分頁的拆分是通過定位分頁上索引鍵的中點(diǎn)，分配新的分頁并將舊的索引分頁中較低的一半復(fù)制到新的分頁來實(shí)現(xiàn)的。同樣地，盡管這比根分頁的拆分要常見一些，但這種情況也并不會經(jīng)常發(fā)生。
拆分?jǐn)?shù)據(jù)分頁
數(shù)據(jù)分頁的拆分是最值得關(guān)注也是最可能發(fā)生的情況，并且這也可能是開發(fā)者唯一應(yīng)該關(guān)注的拆分類型。數(shù)據(jù)分頁的拆分只有在表上存在聚集索引且進(jìn)行插入操作時(shí)才會發(fā)生。如果不存在聚集索引，SQL Server會根據(jù)PFS分頁在任何可以容納新記錄的分頁上完成插入。盡管只有插入行為才會引起拆分，但這種插入行為也可能是update語句產(chǎn)生的結(jié)果，而不僅僅針對insert語句。正如下面將要介紹的，如果行不能在原處被更新或者至少在同一個(gè)分頁中被更新的話，更新操作實(shí)際上就被分解為先刪除原始行再插入行的一個(gè)新版本。當(dāng)然，插入新的記錄還會造成頁拆分。
拆分?jǐn)?shù)據(jù)分頁是一個(gè)復(fù)雜的操作。與拆分中間級索引分頁非常類似的是，SQL Server也是通過定位分頁上的索引鍵的中點(diǎn)，分配新的分頁并將舊的索引分頁中較低的一半復(fù)制到新的分頁來實(shí)現(xiàn)的。這需要索引管理器決定在哪個(gè)分頁上放置新的記錄并且能夠處理原業(yè)的舊分頁和新分頁都不能容納的大的行記錄。當(dāng)數(shù)據(jù)分頁被拆分時(shí)，聚集索引鍵值不會改變，因而非聚集索引也不會受到影響。
下面來看看當(dāng)發(fā)生拆分時(shí)分頁上的情況。下面的腳本新建了一個(gè)具有較大行記錄的數(shù)據(jù)表bigrows---相當(dāng)大，實(shí)際上一個(gè)分頁上只能容納五行數(shù)據(jù)。一旦表被創(chuàng)建并插入五行記錄以后，我們可以通過如下步驟找到該表的第一個(gè)分頁(在本例中也是唯一的分頁):將dbcc ind的輸出結(jié)果插入到sp_table_pages表中，尋找沒有前一頁的數(shù)據(jù)分頁的信息然后使用dbcc page來查看分頁的內(nèi)容。由于沒有必要查看分頁上所有的8020個(gè)字節(jié)的數(shù)據(jù)，我們只需要查看分頁末尾的行偏移數(shù)組并觀察當(dāng)插入第六條記錄時(shí)分頁上的情況。
/*首先創(chuàng)建數(shù)據(jù)表bigrows */
use adventureworks;
GO
drop table bigrows;
GO
create table bigrows
(
a int primary key,
b varchar(1600)
);
GO
/* 向表中插入五行數(shù)據(jù) */
insert into bigrows values(5,replicate('a',1600));
insert into bigrows values(10,replicate('b',1600));
insert into bigrows values(15,replicate('c',1600));
insert into bigrows values(20,replicate('d',1600));
insert into bigrows values(25,replicate('e',1600));
GO
truncate table sp_table_pages;
insert into sp_table_pages exec('dbcc ind(adventureworks,bigrows,-1)');
select pagefid,pagepid from sp_table_pages where pagetype=1;
DBCC 執(zhí)行完畢。如果 DBCC 輸出了錯(cuò)誤信息，請與系統(tǒng)管理員聯(lián)系。
(2 行受影響)
pagefid pagepid
------- -----------
1 20996
(1 行受影響)
dbcc traceon(3604);
GO
dbcc page(adventureworks,1,20996,1);
DBCC 執(zhí)行完畢。如果 DBCC 輸出了錯(cuò)誤信息，請與系統(tǒng)管理員聯(lián)系。
PAGE: (1:20996)
BUFFER:
BUF @0x0000000083FD7F80
bpage = 0x00000000835FE000 bhash = 0x0000000000000000 bpageno = (1:20996)
bdbid = 6 breferences = 0 bUse1 = 686
bstat = 0xc0010b blog = 0x212121bb bnext = 0x0000000000000000
PAGE HEADER:
Page @0x00000000835FE000
m_pageId = (1:20996) m_headerVersion = 1 m_type = 1
m_typeFlagBits = 0x4 m_level = 0 m_flagBits = 0x8000
m_objId (AllocUnitId.idObj) = 346 m_indexId (AllocUnitId.idInd) = 256
Metadata: AllocUnitId = 72057594060603392
Metadata: PartitionId = 72057594054311936 Metadata: IndexId = 1
Metadata: ObjectId = 743673697 m_prevPage = (0:0) m_nextPage = (0:0)
pminlen = 8 m_slotCnt = 5 m_freeCnt = 11
m_freeData = 8171 m_reservedCnt = 0 m_lsn = (134:408:2)
m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0
m_tornBits = 0
Allocation Status
GAM (1:2) = ALLOCATED SGAM (1:3) = ALLOCATED
PFS (1:16176) = 0x60 MIXED_EXT ALLOCATED 0_PCT_FULL DIFF (1:6) = CHANGED
ML (1:7) = NOT MIN_LOGGED
DATA:
Slot 0, Offset 0x60, Length 1615, DumpStyle BYTE
Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
Memory Dump @0x000000000E22C060
0000000000000000: 30000800 05000000 0200fc01 004f0661 ?0............O.a
0000000000000010: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000020: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000030: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000040: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000050: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000060: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000070: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000080: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000090: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000000A0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000000B0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000000C0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000000D0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000000E0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000000F0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000100: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000110: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000120: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000130: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000140: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000150: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000160: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000170: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000180: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000190: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000001A0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000001B0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000001C0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000001D0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000001E0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000001F0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000200: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000210: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000220: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000230: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000240: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000250: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000260: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000270: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000280: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000290: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000002A0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000002B0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000002C0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000002D0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000002E0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000002F0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000300: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000310: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000320: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000330: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000340: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000350: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000360: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000370: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000380: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000390: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000003A0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000003B0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000003C0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000003D0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000003E0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000003F0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000400: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000410: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000420: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000430: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000440: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000450: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000460: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000470: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000480: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000490: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000004A0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000004B0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000004C0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000004D0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000004E0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000004F0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000500: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000510: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000520: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000530: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000540: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000550: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000560: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000570: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000580: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000590: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000005A0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000005B0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000005C0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000005D0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000005E0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
00000000000005F0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000600: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000610: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000620: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000630: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa
0000000000000640: 61616161 61616161 61616161 616161????aaaaaaaaaaaaaaa
Slot 1, Offset 0x6af, Length 1615, DumpStyle BYTE
Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
Memory Dump @0x000000000E22C6AF
0000000000000000: 30000800 0a000000 0200fc01 004f0662 ?0............O.b
0000000000000010: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000020: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000030: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000040: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000050: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000060: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000070: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000080: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000090: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000000A0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000000B0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000000C0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000000D0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000000E0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000000F0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000100: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000110: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000120: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000130: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000140: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000150: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000160: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000170: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000180: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000190: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000001A0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000001B0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000001C0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000001D0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000001E0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000001F0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000200: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000210: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000220: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000230: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000240: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000250: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000260: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000270: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000280: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000290: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000002A0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000002B0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000002C0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000002D0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000002E0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000002F0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000300: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000310: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000320: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000330: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000340: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000350: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000360: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000370: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000380: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000390: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000003A0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000003B0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000003C0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000003D0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000003E0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000003F0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000400: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000410: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000420: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000430: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000440: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000450: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000460: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000470: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000480: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000490: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000004A0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000004B0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000004C0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000004D0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000004E0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000004F0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000500: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000510: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000520: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000530: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000540: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000550: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000560: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000570: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000580: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000590: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000005A0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000005B0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000005C0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000005D0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000005E0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
00000000000005F0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000600: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000610: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000620: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000630: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb
0000000000000640: 62626262 62626262 62626262 626262????bbbbbbbbbbbbbbb
Slot 2, Offset 0xcfe, Length 1615, DumpStyle BYTE
Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
Memory Dump @0x000000000E22CCFE
0000000000000000: 30000800 0f000000 0200fc01 004f0663 ?0............O.c
0000000000000010: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000020: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000030: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000040: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000050: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000060: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000070: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000080: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000090: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000000A0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000000B0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000000C0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000000D0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000000E0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000000F0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000100: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000110: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000120: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000130: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000140: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000150: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000160: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000170: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000180: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000190: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000001A0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000001B0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000001C0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000001D0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000001E0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000001F0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000200: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000210: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000220: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000230: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000240: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000250: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000260: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000270: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000280: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000290: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000002A0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000002B0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000002C0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000002D0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000002E0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000002F0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000300: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000310: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000320: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000330: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000340: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000350: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000360: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000370: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000380: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000390: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000003A0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000003B0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000003C0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000003D0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000003E0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000003F0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000400: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000410: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000420: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000430: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000440: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000450: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000460: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000470: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000480: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000490: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000004A0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000004B0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000004C0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000004D0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000004E0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000004F0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000500: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000510: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000520: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000530: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000540: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000550: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000560: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000570: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000580: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000590: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000005A0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000005B0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000005C0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000005D0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000005E0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
00000000000005F0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000600: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000610: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000620: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000630: 63636363 63636363 63636363 63636363 ?cccccccccccccccc
0000000000000640: 63636363 63636363 63636363 636363????ccccccccccccccc
Slot 3, Offset 0x134d, Length 1615, DumpStyle BYTE
Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
Memory Dump @0x000000000E22D34D
0000000000000000: 30000800 14000000 0200fc01 004f0664 ?0............O.d
0000000000000010: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000020: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000030: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000040: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000050: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000060: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000070: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000080: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000090: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000000A0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000000B0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000000C0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000000D0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000000E0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000000F0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000100: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000110: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000120: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000130: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000140: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000150: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000160: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000170: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000180: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000190: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000001A0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000001B0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000001C0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000001D0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000001E0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000001F0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000200: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000210: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000220: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000230: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000240: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000250: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000260: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000270: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000280: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000290: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000002A0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000002B0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000002C0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000002D0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000002E0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000002F0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000300: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000310: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000320: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000330: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000340: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000350: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000360: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000370: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000380: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000390: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000003A0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000003B0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000003C0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000003D0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000003E0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000003F0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000400: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000410: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000420: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000430: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000440: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000450: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000460: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000470: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000480: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000490: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000004A0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000004B0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000004C0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000004D0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000004E0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000004F0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000500: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000510: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000520: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000530: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000540: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000550: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000560: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000570: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000580: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000590: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000005A0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000005B0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000005C0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000005D0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000005E0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
00000000000005F0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000600: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000610: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000620: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000630: 64646464 64646464 64646464 64646464 ?dddddddddddddddd
0000000000000640: 64646464 64646464 64646464 646464????ddddddddddddddd
Slot 4, Offset 0x199c, Length 1615, DumpStyle BYTE
Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS
Memory Dump @0x000000000E22D99C
0000000000000000: 30000800 19000000 0200fc01 004f0665 ?0............O.e
0000000000000010: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000020: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000030: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000040: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000050: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000060: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000070: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000080: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000090: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000000A0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000000B0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000000C0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000000D0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000000E0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000000F0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000100: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000110: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000120: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000130: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000140: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000150: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000160: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000170: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000180: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000190: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000001A0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000001B0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000001C0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000001D0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000001E0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000001F0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000200: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000210: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000220: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000230: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000240: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000250: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000260: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000270: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000280: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000290: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000002A0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000002B0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000002C0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000002D0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000002E0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000002F0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000300: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000310: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000320: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000330: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000340: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000350: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000360: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000370: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000380: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000390: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000003A0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000003B0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000003C0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000003D0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000003E0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000003F0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000400: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000410: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000420: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000430: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000440: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000450: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000460: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000470: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000480: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000490: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000004A0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000004B0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000004C0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000004D0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000004E0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000004F0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000500: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000510: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000520: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000530: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000540: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000550: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000560: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000570: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000580: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000590: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000005A0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000005B0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000005C0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000005D0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000005E0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
00000000000005F0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000600: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000610: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000620: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000630: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee
0000000000000640: 65656565 65656565 65656565 656565????eeeeeeeeeeeeeee下面是從dbcc page輸出結(jié)果中得到的行偏移數(shù)組:
OFFSET TABLE: Row - Offset 4 (0x4) - 6556 (0x199c) 3 (0x3) - 4941 (0x134d) 2 (0x2) - 3326 (0xcfe) 1 (0x1) - 1711 (0x6af) 0 (0x0) - 96 (0x60) DBCC 執(zhí)行完畢。如果 DBCC 輸出了錯(cuò)誤信息，請與系統(tǒng)管理員聯(lián)系。
下面插入一行新的記錄并再次查看行偏移數(shù)組:
use adventureworks;
GO
insert into bigrows values(22,replicate('x',1600));
GO從m_nextPage = (1:20999)結(jié)果可知現(xiàn)在有兩個(gè)數(shù)據(jù)分頁，下一個(gè)分頁號為20999。
PAGE: (1:20996) BUFFER: BUF @0x0000000083FD7F80 bpage = 0x00000000835FE000 bhash = 0x0000000000000000 bpageno = (1:20996) bdbid = 6 breferences = 0 bUse1 = 4322 bstat = 0xc0010b blog = 0x212121bb bnext = 0x0000000000000000 PAGE HEADER: Page @0x00000000835FE000 m_pageId = (1:20996) m_headerVersion = 1 m_type = 1 m_typeFlagBits = 0x4 m_level = 0 m_flagBits = 0x0 m_objId (AllocUnitId.idObj) = 346 m_indexId (AllocUnitId.idInd) = 256 Metadata: AllocUnitId = 72057594060603392 Metadata: PartitionId = 72057594054311936 Metadata: IndexId = 1 Metadata: ObjectId = 743673697 m_prevPage = (0:0) m_nextPage = (1:20999) pminlen = 8 m_slotCnt = 3 m_freeCnt = 3245 m_freeData = 8171 m_reservedCnt = 0 m_lsn = (134:416:17) m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0 m_tornBits = 0 Allocation Status GAM (1:2) = ALLOCATED SGAM (1:3) = ALLOCATED PFS (1:16176) = 0x60 MIXED_EXT ALLOCATED 0_PCT_FULL DIFF (1:6) = CHANGED ML (1:7) = NOT MIN_LOGGED DATA: Slot 0, Offset 0x60, Length 1615, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS Memory Dump @0x0000000003A8C060 0000000000000000: 30000800 05000000 0200fc01 004f0661 ?0............O.a 0000000000000010: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000020: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000030: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000040: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000050: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000060: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000070: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000080: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000090: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000000A0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000000B0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000000C0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000000D0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000000E0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000000F0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000100: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000110: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000120: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000130: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000140: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000150: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000160: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000170: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000180: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000190: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000001A0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000001B0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000001C0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000001D0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000001E0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000001F0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000200: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000210: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000220: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000230: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000240: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000250: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000260: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000270: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000280: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000290: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000002A0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000002B0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000002C0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000002D0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000002E0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000002F0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000300: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000310: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000320: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000330: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000340: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000350: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000360: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000370: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000380: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000390: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000003A0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000003B0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000003C0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000003D0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000003E0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000003F0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000400: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000410: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000420: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000430: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000440: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000450: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000460: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000470: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000480: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000490: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000004A0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000004B0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000004C0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000004D0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000004E0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000004F0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000500: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000510: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000520: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000530: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000540: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000550: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000560: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000570: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000580: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000590: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000005A0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000005B0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000005C0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000005D0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000005E0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000005F0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000600: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000610: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000620: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000630: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000640: 61616161 61616161 61616161 616161????aaaaaaaaaaaaaaa Slot 1, Offset 0x6af, Length 1615, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS Memory Dump @0x0000000003A8C6AF 0000000000000000: 30000800 0a000000 0200fc01 004f0662 ?0............O.b 0000000000000010: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000020: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000030: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000040: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000050: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000060: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000070: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000080: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000090: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000000A0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000000B0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000000C0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000000D0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000000E0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000000F0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000100: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000110: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000120: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000130: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000140: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000150: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000160: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000170: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000180: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000190: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000001A0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000001B0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000001C0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000001D0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000001E0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000001F0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000200: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000210: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000220: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000230: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000240: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000250: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000260: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000270: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000280: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000290: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000002A0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000002B0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000002C0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000002D0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000002E0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000002F0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000300: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000310: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000320: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000330: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000340: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000350: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000360: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000370: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000380: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000390: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000003A0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000003B0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000003C0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000003D0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000003E0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000003F0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000400: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000410: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000420: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000430: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000440: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000450: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000460: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000470: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000480: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000490: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000004A0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000004B0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000004C0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000004D0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000004E0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000004F0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000500: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000510: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000520: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000530: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000540: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000550: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000560: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000570: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000580: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000590: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000005A0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000005B0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000005C0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000005D0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000005E0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000005F0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000600: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000610: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000620: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000630: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000640: 62626262 62626262 62626262 626262????bbbbbbbbbbbbbbb Slot 2, Offset 0xcfe, Length 1615, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS Memory Dump @0x0000000003A8CCFE 0000000000000000: 30000800 0f000000 0200fc01 004f0663 ?0............O.c 0000000000000010: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000020: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000030: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000040: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000050: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000060: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000070: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000080: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000090: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000000A0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000000B0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000000C0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000000D0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000000E0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000000F0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000100: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000110: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000120: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000130: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000140: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000150: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000160: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000170: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000180: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000190: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000001A0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000001B0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000001C0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000001D0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000001E0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000001F0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000200: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000210: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000220: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000230: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000240: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000250: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000260: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000270: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000280: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000290: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000002A0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000002B0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000002C0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000002D0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000002E0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000002F0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000300: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000310: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000320: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000330: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000340: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000350: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000360: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000370: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000380: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000390: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000003A0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000003B0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000003C0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000003D0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000003E0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000003F0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000400: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000410: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000420: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000430: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000440: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000450: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000460: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000470: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000480: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000490: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000004A0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000004B0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000004C0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000004D0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000004E0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000004F0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000500: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000510: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000520: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000530: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000540: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000550: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000560: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000570: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000580: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000590: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000005A0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000005B0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000005C0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000005D0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000005E0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000005F0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000600: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000610: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000620: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000630: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000640: 63636363 63636363 63636363 636363????ccccccccccccccc OFFSET TABLE: Row - Offset 2 (0x2) - 3326 (0xcfe) 1 (0x1) - 1711 (0x6af) 0 (0x0) - 96 (0x60) DBCC 執(zhí)行完畢。如果 DBCC 輸出了錯(cuò)誤信息，請與系統(tǒng)管理員聯(lián)系。
在拆分后檢查原來的數(shù)據(jù)分頁發(fā)現(xiàn)它既有可能包含原始分頁的上半部分的行記錄也可能是下半部分。SQL Server通常會移動(dòng)記錄因而新插入的記錄會移動(dòng)到新的分頁上去。因?yàn)檫@些行記錄無論如何都會移動(dòng)，因此調(diào)整它們的位置來容納新插入的記錄就更具有意義了。在這個(gè)例子中，新的記錄，其聚集鍵值為22，會被插入到分頁的下半部分中去。因此當(dāng)發(fā)生頁拆分時(shí)，前三行仍然留在原始分頁20996中?？梢詸z查頁頭來找到下一個(gè)包含新記錄的分頁位置。其中,m_nextPage域指明了頁號。該值以十進(jìn)制的格式表示為文件號；分頁號對，因此可以很容易地將其運(yùn)用在dbcc page命令中。當(dāng)我運(yùn)行該查詢時(shí)，得到的m_nextPage的值為1:20999，因此要執(zhí)行如下命令:
use adventureworks; GO dbcc traceon(3604); GO dbcc page(adventureworks,1,20999,1) DBCC 執(zhí)行完畢。如果 DBCC 輸出了錯(cuò)誤信息，請與系統(tǒng)管理員聯(lián)系。 PAGE: (1:20999) BUFFER: BUF @0x0000000083FF9C80 bpage = 0x0000000083E72000 bhash = 0x0000000000000000 bpageno = (1:20999) bdbid = 6 breferences = 0 bUse1 = 7865 bstat = 0xc0010b blog = 0x212121bb bnext = 0x0000000000000000 PAGE HEADER: Page @0x0000000083E72000 m_pageId = (1:20999) m_headerVersion = 1 m_type = 1 m_typeFlagBits = 0x4 m_level = 0 m_flagBits = 0x0 m_objId (AllocUnitId.idObj) = 346 m_indexId (AllocUnitId.idInd) = 256 Metadata: AllocUnitId = 72057594060603392 Metadata: PartitionId = 72057594054311936 Metadata: IndexId = 1 Metadata: ObjectId = 743673697 m_prevPage = (1:20996) m_nextPage = (0:0) pminlen = 8 m_slotCnt = 3 m_freeCnt = 3245 m_freeData = 4941 m_reservedCnt = 0 m_lsn = (134:416:20) m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0 m_tornBits = 0 Allocation Status GAM (1:2) = ALLOCATED SGAM (1:3) = ALLOCATED PFS (1:16176) = 0x60 MIXED_EXT ALLOCATED 0_PCT_FULL DIFF (1:6) = CHANGED ML (1:7) = NOT MIN_LOGGED DATA: Slot 0, Offset 0x60, Length 1615, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS Memory Dump @0x0000000003A8C060 0000000000000000: 30000800 14000000 0200fc01 004f0664 ?0............O.d 0000000000000010: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000020: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000030: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000040: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000050: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000060: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000070: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000080: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000090: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000000A0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000000B0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000000C0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000000D0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000000E0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000000F0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000100: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000110: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000120: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000130: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000140: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000150: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000160: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000170: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000180: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000190: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000001A0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000001B0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000001C0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000001D0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000001E0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000001F0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000200: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000210: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000220: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000230: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000240: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000250: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000260: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000270: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000280: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000290: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000002A0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000002B0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000002C0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000002D0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000002E0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000002F0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000300: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000310: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000320: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000330: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000340: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000350: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000360: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000370: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000380: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000390: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000003A0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000003B0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000003C0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000003D0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000003E0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000003F0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000400: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000410: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000420: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000430: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000440: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000450: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000460: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000470: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000480: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000490: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000004A0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000004B0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000004C0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000004D0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000004E0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000004F0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000500: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000510: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000520: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000530: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000540: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000550: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000560: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000570: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000580: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000590: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000005A0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000005B0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000005C0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000005D0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000005E0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 00000000000005F0: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000600: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000610: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000620: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000630: 64646464 64646464 64646464 64646464 ?dddddddddddddddd 0000000000000640: 64646464 64646464 64646464 646464????ddddddddddddddd Slot 1, Offset 0xcfe, Length 1615, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS Memory Dump @0x0000000003A8CCFE 0000000000000000: 30000800 16000000 0200fc01 004f0678 ?0............O.x 0000000000000010: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000020: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000030: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000040: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000050: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000060: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000070: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000080: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000090: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000000A0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000000B0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000000C0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000000D0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000000E0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000000F0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000100: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000110: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000120: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000130: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000140: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000150: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000160: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000170: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000180: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000190: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000001A0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000001B0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000001C0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000001D0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000001E0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000001F0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000200: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000210: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000220: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000230: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000240: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000250: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000260: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000270: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000280: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000290: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000002A0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000002B0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000002C0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000002D0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000002E0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000002F0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000300: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000310: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000320: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000330: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000340: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000350: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000360: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000370: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000380: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000390: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000003A0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000003B0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000003C0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000003D0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000003E0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000003F0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000400: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000410: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000420: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000430: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000440: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000450: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000460: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000470: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000480: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000490: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000004A0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000004B0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000004C0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000004D0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000004E0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000004F0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000500: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000510: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000520: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000530: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000540: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000550: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000560: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000570: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000580: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000590: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000005A0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000005B0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000005C0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000005D0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000005E0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000005F0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000600: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000610: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000620: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000630: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000640: 78787878 78787878 78787878 787878????xxxxxxxxxxxxxxx Slot 2, Offset 0x6af, Length 1615, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS Memory Dump @0x0000000003A8C6AF 0000000000000000: 30000800 19000000 0200fc01 004f0665 ?0............O.e 0000000000000010: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000020: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000030: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000040: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000050: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000060: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000070: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000080: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000090: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000000A0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000000B0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000000C0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000000D0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000000E0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000000F0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000100: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000110: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000120: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000130: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000140: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000150: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000160: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000170: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000180: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000190: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000001A0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000001B0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000001C0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000001D0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000001E0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000001F0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000200: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000210: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000220: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000230: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000240: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000250: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000260: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000270: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000280: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000290: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000002A0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000002B0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000002C0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000002D0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000002E0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000002F0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000300: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000310: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000320: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000330: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000340: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000350: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000360: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000370: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000380: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000390: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000003A0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000003B0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000003C0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000003D0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000003E0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000003F0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000400: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000410: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000420: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000430: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000440: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000450: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000460: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000470: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000480: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000490: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000004A0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000004B0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000004C0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000004D0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000004E0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000004F0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000500: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000510: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000520: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000530: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000540: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000550: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000560: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000570: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000580: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000590: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000005A0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000005B0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000005C0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000005D0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000005E0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 00000000000005F0: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000600: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000610: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000620: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000630: 65656565 65656565 65656565 65656565 ?eeeeeeeeeeeeeeee 0000000000000640: 65656565 65656565 65656565 656565????eeeeeeeeeeeeeee OFFSET TABLE:
下面是插入以后第二個(gè)分頁上的行偏移數(shù)組:
Row - Offset 2 (0x2) - 1711 (0x6af) 1 (0x1) - 3326 (0xcfe) 0 (0x0) - 96 (0x60) DBCC 執(zhí)行完畢。如果 DBCC 輸出了錯(cuò)誤信息，請與系統(tǒng)管理員聯(lián)系。
注意，在頁拆分以后，此分頁上有三行記錄:原始分頁上的后兩條記錄(鍵值為20和25)，以及值為22的新記錄。如果檢查分頁上的實(shí)際數(shù)據(jù)的話，會注意到新的記錄在槽號(slot)為1的地方，即使該記錄本身的確是分頁上物理順序中的最后條記錄。槽1(鍵值為22)從偏移量3326處開始，而槽2(鍵值為25)則從偏移量1711處開始。行的聚集索引鍵序是由行的槽號指明的，而不是在分頁上的物理位置。如果數(shù)據(jù)表包含聚集索引，那么在槽1處的記錄的鍵值總是小于槽2處記錄的鍵值而大于槽0處記錄的鍵值。
盡管典型的頁拆分的代價(jià)并不十分高昂，但是用戶還是希望能夠盡可能降低生產(chǎn)系統(tǒng)中的頁拆分頻率，至少在使用高峰的時(shí)刻會如此。一次頁拆分開鎖很低，但成千上百的拆分就不是了?？梢酝ㄟ^在現(xiàn)有數(shù)據(jù)上創(chuàng)建聚集索引時(shí)使用filefactor子句在分頁上預(yù)留一些空間來避免高峰時(shí)刻可能的系統(tǒng)崩潰。可以在系統(tǒng)運(yùn)營最不繁忙的時(shí)雄姿英發(fā)定期使用期望的填充因子重建索引對系統(tǒng)進(jìn)行優(yōu)化。按照這種方式，在高峰時(shí)刻依然有額外的空間可以使用，并且可以因此節(jié)省拆分帶來的開鎖。如果系統(tǒng)不存在“不活躍”的時(shí)間，可以使用alter index對索引進(jìn)行重組并調(diào)整填充因子，而不必使整張表都陷入不可使用的狀態(tài)。注意：帶有reorganize的alter index語句只能通過壓縮數(shù)據(jù)和轉(zhuǎn)移分頁來調(diào)整填充因子，它不會通過添加新的分頁來重置填充因子。利用SQL Server代理可以很輕松地在系統(tǒng)不繁忙時(shí)安排索引的重建或重組。
刪除數(shù)據(jù)
當(dāng)從一張數(shù)據(jù)表中刪除記錄時(shí)，必須同時(shí)考慮數(shù)據(jù)分頁和索引分頁上的變化。謹(jǐn)記聚集索引的葉級別實(shí)際上就是數(shù)據(jù)本身，而從帶有聚集索引的表中刪除數(shù)據(jù)的方式與從非聚集索引 的葉級別刪除記錄完全一樣。從堆表中刪除記錄則是另一種處理方式，類似于從索引的結(jié)點(diǎn)分頁中進(jìn)行刪除。
從堆表中刪除記錄
SQL Server 2005不會在行被刪除時(shí)自動(dòng)壓縮分頁上的空間?？紤]到性能優(yōu)化，在分頁需要額外的連續(xù)空間來插入新的記錄以前都不會進(jìn)行數(shù)據(jù)壓縮。下面的盒子從分頁中間刪除一行數(shù)據(jù)然后使用dbcc page來查看分頁。
use adventureworks;
GO
create table smallrows
(
a int identity,
b char(10)
);
GO
insert into smallrows values('row 1');
insert into smallrows values('row 2');
insert into smallrows values('row 3');
insert into smallrows values('row 4');
insert into smallrows values('row 5');
truncate table sp_table_pages;
insert into sp_table_pages exec('dbcc ind(adventureworks,smallrows,-1)');
select pagefid,pagepid from sp_table_pages where pagetype=1;
結(jié)果:
pagefid pagepid
------- -----------
1 21920
(1 行受影響)
use adventureworks;
GO
dbcc traceon(3604);
GO
dbcc page(adventureworks,1,21920,1)下面是dbcc page的輸出結(jié)果
PAGE: (1:21920) BUFFER: BUF @0x0000000083FF9480 bpage = 0x0000000083E52000 bhash = 0x0000000000000000 bpageno = (1:21920) bdbid = 6 breferences = 0 bUse1 = 3478 bstat = 0xc0010b blog = 0x212121bb bnext = 0x0000000000000000 PAGE HEADER: Page @0x0000000083E52000 m_pageId = (1:21920) m_headerVersion = 1 m_type = 1 m_typeFlagBits = 0x4 m_level = 0 m_flagBits = 0x8000 m_objId (AllocUnitId.idObj) = 347 m_indexId (AllocUnitId.idInd) = 256 Metadata: AllocUnitId = 72057594060668928 Metadata: PartitionId = 72057594054377472 Metadata: IndexId = 0 Metadata: ObjectId = 775673811 m_prevPage = (0:0) m_nextPage = (0:0) pminlen = 18 m_slotCnt = 5 m_freeCnt = 7981 m_freeData = 201 m_reservedCnt = 0 m_lsn = (134:472:3) m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0 m_tornBits = 0 Allocation Status GAM (1:2) = ALLOCATED SGAM (1:3) = ALLOCATED PFS (1:16176) = 0x61 MIXED_EXT ALLOCATED 50_PCT_FULL DIFF (1:6) = CHANGED ML (1:7) = NOT MIN_LOGGED DATA: Slot 0, Offset 0x60, Length 21, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000E22C060 0000000000000000: 10001200 01000000 726f7720 31202020 ?........row 1 0000000000000010: 20200200 fc?????????????????????????? ... Slot 1, Offset 0x75, Length 21, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000E22C075 0000000000000000: 10001200 02000000 726f7720 32202020 ?........row 2 0000000000000010: 20200200 fc?????????????????????????? ... Slot 2, Offset 0x8a, Length 21, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000E22C08A 0000000000000000: 10001200 03000000 726f7720 33202020 ?........row 3 0000000000000010: 20200200 fc?????????????????????????? ... Slot 3, Offset 0x9f, Length 21, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000E22C09F 0000000000000000: 10001200 04000000 726f7720 34202020 ?........row 4 0000000000000010: 20200200 fc?????????????????????????? ... Slot 4, Offset 0xb4, Length 21, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000E22C0B4 0000000000000000: 10001200 05000000 726f7720 35202020 ?........row 5 0000000000000010: 20200200 fc?????????????????????????? ... OFFSET TABLE: Row - Offset 4 (0x4) - 180 (0xb4) 3 (0x3) - 159 (0x9f) 2 (0x2) - 138 (0x8a) 1 (0x1) - 117 (0x75) 0 (0x0) - 96 (0x60)
現(xiàn)在刪除中間一行數(shù)據(jù)(where a=3)并再次查看分頁的內(nèi)容
use adventureworks; GO delete from smallrows where a=3; GO dbcc traceon(3604); GO dbcc page(adventureworks,1,21920,1)
下面是第二次執(zhí)行dbcc page的輸出結(jié)果
PAGE: (1:21920) BUFFER: BUF @0x0000000083FF9480 bpage = 0x0000000083E52000 bhash = 0x0000000000000000 bpageno = (1:21920) bdbid = 6 breferences = 3 bUse1 = 3693 bstat = 0xc0010b blog = 0x212121bb bnext = 0x0000000000000000 PAGE HEADER: Page @0x0000000083E52000 m_pageId = (1:21920) m_headerVersion = 1 m_type = 1 m_typeFlagBits = 0x4 m_level = 0 m_flagBits = 0x8008 m_objId (AllocUnitId.idObj) = 347 m_indexId (AllocUnitId.idInd) = 256 Metadata: AllocUnitId = 72057594060668928 Metadata: PartitionId = 72057594054377472 Metadata: IndexId = 0 Metadata: ObjectId = 775673811 m_prevPage = (0:0) m_nextPage = (0:0) pminlen = 18 m_slotCnt = 5 m_freeCnt = 8002 m_freeData = 201 m_reservedCnt = 21 m_lsn = (134:488:2) m_xactReserved = 21 m_xdesId = (0:18192) m_ghostRecCnt = 0 m_tornBits = 0 Allocation Status GAM (1:2) = ALLOCATED SGAM (1:3) = ALLOCATED PFS (1:16176) = 0x61 MIXED_EXT ALLOCATED 50_PCT_FULL DIFF (1:6) = CHANGED ML (1:7) = NOT MIN_LOGGED DATA: Slot 0, Offset 0x60, Length 21, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000E22C060 0000000000000000: 10001200 01000000 726f7720 31202020 ?........row 1 0000000000000010: 20200200 fc?????????????????????????? ... Slot 1, Offset 0x75, Length 21, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000E22C075 0000000000000000: 10001200 02000000 726f7720 32202020 ?........row 2 0000000000000010: 20200200 fc?????????????????????????? ... Slot 3, Offset 0x9f, Length 21, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000E22C09F 0000000000000000: 10001200 04000000 726f7720 34202020 ?........row 4 0000000000000010: 20200200 fc?????????????????????????? ... Slot 4, Offset 0xb4, Length 21, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000E22C0B4 0000000000000000: 10001200 05000000 726f7720 35202020 ?........row 5 0000000000000010: 20200200 fc?????????????????????????? ... OFFSET TABLE: Row - Offset 4 (0x4) - 180 (0xb4) 3 (0x3) - 159 (0x9f) 2 (0x2) - 0 (0x0) 1 (0x1) - 117 (0x75) 0 (0x0) - 96 (0x60)
注意在堆表中，這行數(shù)據(jù)就不會出現(xiàn)在分頁中了。分頁底部的行偏移數(shù)組顯示第三行數(shù)據(jù)(槽2)現(xiàn)在位于偏移量0處(這意味著現(xiàn)在沒有行使用槽2)，而占用槽3的行仍然在位于和刪除前相同的偏移量處。分頁上的數(shù)據(jù)并沒有被壓縮。
除了分頁上的空間不被回收之外，堆表中的空閑分頁也經(jīng)常無法被回收。即使從堆表中刪除了全部記錄。SQL Server不會將空閑分頁標(biāo)記成未分配狀態(tài)，因此這部分空間無法供其他對象使用。目錄視圖sys.dm_db_partition_stats會顯示這塊空間仍然屬于堆表。
從B樹中刪除記錄
在索引的葉級別(無論聚集索引還是非聚集索引)，當(dāng)行記錄被刪除時(shí)，SQL Server會將其標(biāo)記為虛影記錄。這意味著這行記錄仍然保留在分頁上但是SQL Server會修改記錄頭中的一個(gè)比特位用來表示這行數(shù)據(jù)實(shí)際上是一個(gè)虛影。頁頭中也會反映出分頁上的虛影記錄數(shù)量。虛影記錄有多種用途。它們可以使用回滾操作具有更高的效率；如果這行記錄還沒有被物理地移除掉，那么SQL Server要回滾刪除操作的話就只需修改表示行為虛影的那個(gè)比特位即可。同樣，虛影記錄也是一種針對鍵范圍鎖定以及其他鎖定模式的并發(fā)優(yōu)化。虛影記錄也被用來支持行版本控制。
虛影記錄遲早還是會被清除掉的，取決于系統(tǒng)的負(fù)荷情況，而且有時(shí)SQL Server會在你有機(jī)會查看到以前就將其清除掉了。在下面所示的代碼中，如果執(zhí)行delete操作并等待一會兒再運(yùn)行dbcc page的話，虛影記錄可能就真的消失了。這就是為什么要在運(yùn)行delete以前察看表中的分頁數(shù)量，這樣就可以在查詢窗口中一次點(diǎn)擊執(zhí)行delete和dbcc page命令。為了確保虛影不被清除掉，可以將delete放到一個(gè)用戶事務(wù)中并且在檢查分頁之前不提交或回滾該事務(wù)。清理線程不會清除屬于活動(dòng)事務(wù)的虛影記錄。另外，可以使用未記載的跟蹤標(biāo)記661禁用虛影清理以確保像這個(gè)腳本一樣運(yùn)行浿時(shí)能夠有一致的結(jié)果。通常，請記住未被記載的跟蹤標(biāo)記并不能保證在任何后續(xù)版本或者service pack中繼續(xù)工作，并且不被微軟支持。還要明確在完成測試以后必須關(guān)閉跟蹤標(biāo)記。
下面的例子新建了與前面delete例子中相同的數(shù)據(jù)表，但這次聲明了一個(gè)主鍵，這意味著SQL Server會創(chuàng)建一個(gè)聚集索引。聚集索引的葉級別就是實(shí)際的數(shù)據(jù)，因此當(dāng)記錄被移除時(shí)，會被標(biāo)記為虛影。
use adventureworks;
GO
drop table smallrows;
GO
create table smallrows
(
a int identity primary key,
b char(10)
);
GO
insert into smallrows values('row 1');
insert into smallrows values('row 2');
insert into smallrows values('row 3');
insert into smallrows values('row 4');
insert into smallrows values('row 5');
truncate table sp_table_pages;
insert into sp_table_pages exec('dbcc ind(adventureworks,smallrows,-1)');
select pagefid,pagepid from sp_table_pages where pagetype=1;
結(jié)果:
pagefid pagepid
------- -----------
1 21928
use adventureworks;
GO
delete from smallrows where a=3;
GO
dbcc traceon(3604);
GO
dbcc page(adventureworks,1,21928,1)下面是dbcc page的輸出結(jié)果:
PAGE: (1:21928) BUFFER: BUF @0x0000000084FF6000 bpage = 0x0000000084D80000 bhash = 0x0000000000000000 bpageno = (1:21928) bdbid = 6 breferences = 3 bUse1 = 5368 bstat = 0xc0010b blog = 0x212121bb bnext = 0x0000000000000000 PAGE HEADER: Page @0x0000000084D80000 m_pageId = (1:21928) m_headerVersion = 1 m_type = 1 m_typeFlagBits = 0x4 m_level = 0 m_flagBits = 0x0 m_objId (AllocUnitId.idObj) = 348 m_indexId (AllocUnitId.idInd) = 256 Metadata: AllocUnitId = 72057594060734464 Metadata: PartitionId = 72057594054443008 Metadata: IndexId = 1 Metadata: ObjectId = 791673868 m_prevPage = (0:0) m_nextPage = (0:0) pminlen = 18 m_slotCnt = 5 m_freeCnt = 7981 m_freeData = 201 m_reservedCnt = 0 m_lsn = (134:576:2) m_xactReserved = 0 m_xdesId = (0:18204) m_ghostRecCnt = 1 m_tornBits = 0 Allocation Status GAM (1:2) = ALLOCATED SGAM (1:3) = ALLOCATED PFS (1:16176) = 0x68 MIXED_EXT ALLOCATED 0_PCT_FULL DIFF (1:6) = CHANGED ML (1:7) = NOT MIN_LOGGED DATA: Slot 0, Offset 0x60, Length 21, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000E22C060 0000000000000000: 10001200 01000000 726f7720 31202020 ?........row 1 0000000000000010: 20200200 fc?????????????????????????? ... Slot 1, Offset 0x75, Length 21, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000E22C075 0000000000000000: 10001200 02000000 726f7720 32202020 ?........row 2 0000000000000010: 20200200 fc?????????????????????????? ... Slot 2, Offset 0x8a, Length 21, DumpStyle BYTE Record Type = GHOST_DATA_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000E22C08A 0000000000000000: 1c001200 03000000 726f7720 33202020 ?........row 3 0000000000000010: 20200200 fc?????????????????????????? ... Slot 3, Offset 0x9f, Length 21, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000E22C09F 0000000000000000: 10001200 04000000 726f7720 34202020 ?........row 4 0000000000000010: 20200200 fc?????????????????????????? ... Slot 4, Offset 0xb4, Length 21, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP Memory Dump @0x000000000E22C0B4 0000000000000000: 10001200 05000000 726f7720 35202020 ?........row 5 0000000000000010: 20200200 fc?????????????????????????? ... OFFSET TABLE: Row - Offset 4 (0x4) - 180 (0xb4) 3 (0x3) - 159 (0x9f) 2 (0x2) - 138 (0x8a) 1 (0x1) - 117 (0x75) 0 (0x0) - 96 (0x60)
注意，這行記錄仍然會出現(xiàn)在分頁中，因?yàn)閿?shù)據(jù)表帶有聚集索引。行的頭信息表明這的確是一條虛影記錄。分頁末尾的行偏移數(shù)組顯示槽2中的記錄仍然在相同的偏移量處而且所有記錄都和刪除以前所在的位置相同。另外，頁頭還提供了分頁中虛影記錄的數(shù)量(m_ghostRecCnt = 1)。可以通過sys.dm_db_index_physical_stats看到數(shù)據(jù)表中虛影記錄的總數(shù)
刪除索引結(jié)點(diǎn)級中的記錄
當(dāng)從表中刪除一行數(shù)據(jù)時(shí)，SQL Server必須維護(hù)所有的非聚集索引，因?yàn)槊總€(gè)非聚集索引都有一個(gè)指針指向現(xiàn)在消失了的那條記錄。索引結(jié)點(diǎn)分頁中的記錄在被刪除以后并不是虛影記錄，但是與堆表分頁一樣，直到新的索引行需要該分頁中的空間時(shí)，SQL Server才會壓縮空間。
回收分頁
當(dāng)數(shù)據(jù)分頁中的最后一條記錄都被刪除時(shí)，整個(gè)分頁就被回收。例外發(fā)生在表是堆表結(jié)構(gòu)的時(shí)候，正如之前討論過的(如果此分頁是表中剩下的唯一分頁的話是不會被回收的。一張數(shù)據(jù)表總是包含至少一個(gè)分頁，即使該分頁是空的）。數(shù)據(jù)分頁的回收將導(dǎo)致SQL Server刪除索引分頁中指向被回收的數(shù)據(jù)分頁的那行記錄。如果索引行被刪除的話，那么索引分頁就會被回收(同樣，可能在刪除/插入/更新策略時(shí)發(fā)生)，只在索引分頁中保留一個(gè)條目。該條目會被移到相鄰的分頁中，然后SQL Server將回收這個(gè)空閑分頁。
到目前為止，所有的討論都集中在刪除一行記錄所必需的分頁操作上。如果一個(gè)刪除操作刪除掉多行記錄，用戶必須注意一些其他事項(xiàng)。由于在單個(gè)查詢中修改多條記錄對于插入，更新以及刪除操作來說都是相同的。
更新行
SQL Server有多種方式可以更新行記錄，它會自動(dòng)隱式地為特定的操作選擇最快速的更新策略。在決定策略的過程中，SQL Server會估計(jì)受到影響的記錄數(shù)，按照怎樣的方式訪問記錄（通過掃描，或者一次索引和索引獲取）以及是否會對索引鍵進(jìn)行修改。更新可以由查詢處理器或者存儲引擎來控制。在本小節(jié)中，我們只研究更新究竟按照原位替換的方式進(jìn)行還是SQL Server將其按照兩個(gè)獨(dú)立的操作來處理；刪除舊行并插入新行。更新是由哪個(gè)組件控制的問題；查詢處理器還是存儲引擎，實(shí)際上與所有數(shù)據(jù)修改操作都有關(guān)聯(lián)（并不只與更新相關(guān)）。
移動(dòng)行
如果表中的一條記錄必須移到新的位置時(shí)又會怎么樣呢？在SQL Server 2005中，當(dāng)一條帶有變長字段的記錄被更新了一個(gè)新的較大的值，使得原始分頁無法再容納此記錄時(shí)，會發(fā)生移動(dòng)行的情況。這也可能在改變聚集索引的字段時(shí)發(fā)生，因?yàn)閿?shù)據(jù)行是根據(jù)聚集鍵進(jìn)行邏輯排序的。舉例來說，如果在lastname字段上有一個(gè)聚集索引，那么一條lastname值為Abbot的記錄會存儲到接近表頭的位置。如果接著將lastname值更新為Zappa，那么就必須將這行數(shù)據(jù)移到靠近表尾的地方。
前面部分曾經(jīng)了解了索引的結(jié)構(gòu)并知道非聚集索引的葉級別的每個(gè)結(jié)點(diǎn)都包含一個(gè)行定位符（或者書簽）指向數(shù)據(jù)表中的每行記錄。如果表上有聚集索引，那么行定位符就是該行數(shù)據(jù)的聚集鍵。因此，當(dāng)且僅當(dāng)聚集索引鍵被更新時(shí)，才需要在每個(gè)非聚集索引中進(jìn)行相應(yīng)的修改。請?jiān)跊Q定要在哪些字段上創(chuàng)建聚集索引的時(shí)候牢記這點(diǎn)。最好在非易失性的字段上創(chuàng)建聚集索引。
如果行的移動(dòng)是因?yàn)樵瓉淼姆猪摬荒茉偃菁{這行數(shù)據(jù)。它依然會保持相同的行定位符（換而言之，該行數(shù)據(jù)的聚集鍵保持不變），并且沒有非聚集索引需要被修改。
在索引內(nèi)部機(jī)理的討論中也了解了如果數(shù)據(jù)表上沒有聚集索引（換而言之，仍然是堆表結(jié)構(gòu)），那么存在非聚集索引中的行定位符實(shí)際上就是行的物理位置。在SQL Server 2005中，如果堆中的一行記錄要移到新的分頁上去，該記錄會在原來的位置留下一個(gè)“前轉(zhuǎn)指針”(forwarding pointer)。SQL Server無需改變非聚集索引，它們依舊指向原來的位置，并從原位出發(fā)指向新的位置。
下面來看一個(gè)例子。首先新建一張表，與之前演示插入操作的那張表十分相似，但是該表還有第三個(gè)變長字段。當(dāng)向這張表插入五條數(shù)據(jù)以后，會填滿這個(gè)分頁，然后更新其中一行記錄使第三個(gè)字段變得相當(dāng)長。原始分頁就無法再容納這行數(shù)據(jù)，因此必須被移動(dòng)。接著可以將dbcc ind的輸出結(jié)果導(dǎo)入sp_table_pages數(shù)據(jù)表中，以得到該表所使用的分頁數(shù)目。
use adventureworks;
GO
drop table bigrows;
GO
create table bigrows
(
a int identity,
b varchar(1600),
c varchar(1600)
);
GO
insert into bigrows values(replicate('a',1600),'');
insert into bigrows values(replicate('b',1600),'');
insert into bigrows values(replicate('c',1600),'');
insert into bigrows values(replicate('d',1600),'');
insert into bigrows values(replicate('e',1600),'');
GO
update bigrows set c=replicate('x',1600) where a=3;
GO
truncate table sp_table_pages;
insert into sp_table_pages exec('dbcc ind(adventureworks,bigrows,-1)');
select pagefid,pagepid from sp_table_pages where pagetype=1;查看輸出結(jié)果:
pagefid pagepid ------- ----------- 1 20996 1 20997 use adventureworks; GO dbcc traceon(3604); GO dbcc page(adventureworks,1,20996,1) PAGE: (1:20996)
輸出結(jié)果如下:
BUFFER: BUF @0x0000000083FD7F80 bpage = 0x00000000835FE000 bhash = 0x0000000000000000 bpageno = (1:20996) bdbid = 6 breferences = 0 bUse1 = 42333 bstat = 0xc0010b blog = 0x2121bbbb bnext = 0x0000000000000000 PAGE HEADER: Page @0x00000000835FE000 m_pageId = (1:20996) m_headerVersion = 1 m_type = 1 m_typeFlagBits = 0x4 m_level = 0 m_flagBits = 0x8 m_objId (AllocUnitId.idObj) = 349 m_indexId (AllocUnitId.idInd) = 256 Metadata: AllocUnitId = 72057594060800000 Metadata: PartitionId = 72057594054508544 Metadata: IndexId = 0 Metadata: ObjectId = 823673982 m_prevPage = (0:0) m_nextPage = (0:0) pminlen = 8 m_slotCnt = 5 m_freeCnt = 1617 m_freeData = 8180 m_reservedCnt = 1606 m_lsn = (134:664:13) m_xactReserved = 1606 m_xdesId = (0:18215) m_ghostRecCnt = 0 m_tornBits = 0 Allocation Status GAM (1:2) = ALLOCATED SGAM (1:3) = ALLOCATED PFS (1:16176) = 0x63 MIXED_EXT ALLOCATED 95_PCT_FULL DIFF (1:6) = CHANGED ML (1:7) = NOT MIN_LOGGED DATA: Slot 0, Offset 0x60, Length 1615, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS Memory Dump @0x000000000E9DC060 0000000000000000: 30000800 01000000 0300f801 004f0661 ?0............O.a 0000000000000010: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000020: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000030: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000040: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000050: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000060: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000070: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000080: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000090: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000000A0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000000B0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000000C0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000000D0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000000E0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000000F0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000100: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000110: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000120: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000130: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000140: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000150: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000160: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000170: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000180: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000190: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000001A0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000001B0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000001C0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000001D0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000001E0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000001F0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000200: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000210: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000220: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000230: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000240: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000250: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000260: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000270: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000280: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000290: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000002A0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000002B0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000002C0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000002D0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000002E0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000002F0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000300: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000310: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000320: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000330: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000340: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000350: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000360: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000370: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000380: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000390: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000003A0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000003B0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000003C0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000003D0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000003E0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000003F0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000400: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000410: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000420: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000430: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000440: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000450: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000460: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000470: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000480: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000490: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000004A0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000004B0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000004C0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000004D0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000004E0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000004F0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000500: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000510: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000520: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000530: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000540: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000550: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000560: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000570: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000580: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000590: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000005A0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000005B0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000005C0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000005D0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000005E0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 00000000000005F0: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000600: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000610: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000620: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000630: 61616161 61616161 61616161 61616161 ?aaaaaaaaaaaaaaaa 0000000000000640: 61616161 61616161 61616161 616161????aaaaaaaaaaaaaaa Slot 1, Offset 0x6af, Length 1615, DumpStyle BYTE Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS Memory Dump @0x000000000E9DC6AF 0000000000000000: 30000800 02000000 0300f801 004f0662 ?0............O.b 0000000000000010: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000020: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000030: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000040: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000050: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000060: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000070: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000080: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000090: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000000A0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000000B0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000000C0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000000D0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000000E0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000000F0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000100: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000110: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000120: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000130: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000140: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000150: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000160: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000170: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000180: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000190: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000001A0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000001B0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000001C0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000001D0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000001E0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000001F0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000200: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000210: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000220: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000230: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000240: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000250: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000260: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000270: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000280: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000290: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000002A0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000002B0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000002C0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000002D0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000002E0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000002F0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000300: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000310: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000320: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000330: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000340: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000350: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000360: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000370: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000380: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000390: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000003A0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000003B0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000003C0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000003D0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000003E0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000003F0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000400: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000410: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000420: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000430: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000440: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000450: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000460: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000470: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000480: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000490: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000004A0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000004B0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000004C0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000004D0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000004E0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000004F0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000500: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000510: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000520: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000530: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000540: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000550: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000560: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000570: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000580: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000590: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000005A0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000005B0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000005C0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000005D0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000005E0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 00000000000005F0: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000600: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000610: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000620: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000630: 62626262 62626262 62626262 62626262 ?bbbbbbbbbbbbbbbb 0000000000000640: 62626262 62626262 62626262 626262????bbbbbbbbbbbbbbb
a=3的記錄所在槽2的內(nèi)容如下:
Slot 2, Offset 0x1feb, Length 9, DumpStyle BYTE Record Type = FORWARDING_STUB Record Attributes = Memory Dump @0x000000000E9DDFEB 0000000000000000: 04055200 00010000 00?????????????????..R......
第一個(gè)字節(jié)的值為4(04)意味著這只是一個(gè)前轉(zhuǎn)部分。后三個(gè)字節(jié)005205是記錄移動(dòng)的目的分頁號。由于只是一個(gè)十六進(jìn)制的值，需要將其轉(zhuǎn)化成十進(jìn)制值20997。下一組四個(gè)字節(jié)表明分頁在文件號為1，槽號為0的地方。如果接著使用dbcc page來查看分頁20997，可以看到前轉(zhuǎn)記錄的模樣。
select CONVERT(bigint, CAST(0x005205 As varbinary)); -------------------- 20997 (1 行受影響) use adventureworks; GO dbcc traceon(3604); GO dbcc page(adventureworks,1,20997,1)
輸出結(jié)果如下:
PAGE: (1:20997) BUFFER: BUF @0x0000000080FF9180 bpage = 0x0000000080E46000 bhash = 0x0000000000000000 bpageno = (1:20997) bdbid = 6 breferences = 0 bUse1 = 44564 bstat = 0xc0010b blog = 0x12121bbb bnext = 0x0000000000000000 PAGE HEADER: Page @0x0000000080E46000 m_pageId = (1:20997) m_headerVersion = 1 m_type = 1 m_typeFlagBits = 0x4 m_level = 0 m_flagBits = 0x8000 m_objId (AllocUnitId.idObj) = 349 m_indexId (AllocUnitId.idInd) = 256 Metadata: AllocUnitId = 72057594060800000 Metadata: PartitionId = 72057594054508544 Metadata: IndexId = 0 Metadata: ObjectId = 823673982 m_prevPage = (0:0) m_nextPage = (0:0) pminlen = 8 m_slotCnt = 1 m_freeCnt = 4865 m_freeData = 4952 m_reservedCnt = 0 m_lsn = (134:664:10) m_xactReserved = 0 m_xdesId = (0:0) m_ghostRecCnt = 0 m_tornBits = 0 Allocation Status GAM (1:2) = ALLOCATED SGAM (1:3) = ALLOCATED PFS (1:16176) = 0x61 MIXED_EXT ALLOCATED 50_PCT_FULL DIFF (1:6) = CHANGED ML (1:7) = NOT MIN_LOGGED DATA: Slot 0, Offset 0x6bb, Length 3229, DumpStyle BYTE Record Type = FORWARDED_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS Memory Dump @0x0000000010F1C6BB 0000000000000000: 32000800 03000000 0300f803 00530693 ?2............S.. 0000000000000010: 0c9d8c63 63636363 63636363 63636363 ?...ccccccccccccc 0000000000000020: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000030: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000040: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000050: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000060: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000070: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000080: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000090: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000000A0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000000B0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000000C0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000000D0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000000E0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000000F0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000100: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000110: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000120: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000130: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000140: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000150: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000160: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000170: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000180: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000190: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000001A0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000001B0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000001C0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000001D0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000001E0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000001F0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000200: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000210: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000220: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000230: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000240: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000250: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000260: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000270: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000280: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000290: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000002A0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000002B0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000002C0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000002D0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000002E0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000002F0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000300: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000310: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000320: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000330: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000340: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000350: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000360: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000370: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000380: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000390: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000003A0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000003B0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000003C0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000003D0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000003E0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000003F0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000400: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000410: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000420: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000430: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000440: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000450: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000460: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000470: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000480: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000490: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000004A0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000004B0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000004C0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000004D0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000004E0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000004F0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000500: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000510: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000520: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000530: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000540: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000550: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000560: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000570: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000580: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000590: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000005A0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000005B0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000005C0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000005D0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000005E0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 00000000000005F0: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000600: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000610: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000620: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000630: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000640: 63636363 63636363 63636363 63636363 ?cccccccccccccccc 0000000000000650: 63636378 78787878 78787878 78787878 ?cccxxxxxxxxxxxxx 0000000000000660: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000670: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000680: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000690: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000006A0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000006B0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000006C0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000006D0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000006E0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000006F0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000700: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000710: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000720: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000730: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000740: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000750: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000760: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000770: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000780: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000790: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000007A0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000007B0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000007C0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000007D0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000007E0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000007F0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000800: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000810: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000820: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000830: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000840: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000850: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000860: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000870: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000880: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000890: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000008A0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000008B0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000008C0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000008D0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000008E0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000008F0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000900: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000910: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000920: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000930: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000940: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000950: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000960: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000970: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000980: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000990: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000009A0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000009B0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000009C0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000009D0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000009E0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 00000000000009F0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000A00: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000A10: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000A20: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000A30: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000A40: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000A50: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000A60: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000A70: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000A80: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000A90: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000AA0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000AB0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000AC0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000AD0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000AE0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000AF0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000B00: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000B10: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000B20: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000B30: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000B40: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000B50: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000B60: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000B70: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000B80: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000B90: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000BA0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000BB0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000BC0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000BD0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000BE0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000BF0: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000C00: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000C10: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000C20: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000C30: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000C40: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000C50: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000C60: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000C70: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000C80: 78787878 78787878 78787878 78787878 ?xxxxxxxxxxxxxxxx 0000000000000C90: 78787800 04045200 00010002 00????????xxx...R...... OFFSET TABLE: Row - Offset 0 (0x0) - 1723 (0x6bb)
前轉(zhuǎn)指針
前轉(zhuǎn)指針允許用戶在堆中修改數(shù)據(jù)而無需擔(dān)心對非聚集索引帶來較嚴(yán)重的影響。如果一條已經(jīng)被前轉(zhuǎn)的記錄必須再次移動(dòng)，最初的前轉(zhuǎn)指針就被更新并指向新的位置。如果還要繼續(xù)移動(dòng)，那么前轉(zhuǎn)指針就會不斷地指向另一個(gè)前轉(zhuǎn)指針。另外，如果前轉(zhuǎn)記錄收縮到其原始位置足以能夠容納時(shí)，這條記錄會被移回到原始位置，如果分頁上還有可用空間的話，前轉(zhuǎn)指針就會被刪除。
SQL Server的后續(xù)版本可能會包括一些機(jī)制對堆表中的數(shù)據(jù)進(jìn)行物理的重組，這將消除前轉(zhuǎn)指針的作用。注意前轉(zhuǎn)指針只存在于堆表中，并且alter table的重組選項(xiàng)對于堆表來說是不起作用的?？梢詫Χ驯砩系姆蔷奂饕M(jìn)行碎片整理但是不能對表本身。目前來說，當(dāng)前轉(zhuǎn)指針創(chuàng)建完以后就永遠(yuǎn)呆在原地---除了個(gè)別例外情況。第一種例外已經(jīng)提到過，行會收縮并返回其初始位置。第二種例外是數(shù)據(jù)庫收縮時(shí)。當(dāng)文件收縮時(shí)，SQL Server實(shí)際上會為書簽進(jìn)行再分配。收縮進(jìn)程不會產(chǎn)生前轉(zhuǎn)指針。對于因?yàn)槭湛s進(jìn)程而被移除的分頁來說，它們包含的任何前轉(zhuǎn)指針或者殘余部分實(shí)際上都處于“未前轉(zhuǎn)”的狀態(tài)。前轉(zhuǎn)指針被移除的其他情況十分明顯，譬如前轉(zhuǎn)記錄被刪除或者在表上創(chuàng)建聚集索引從而使其不再是堆表結(jié)構(gòu)。
以上是“sql server 2005數(shù)據(jù)修改的示例分析”這篇文章的所有內(nèi)容，感謝各位的閱讀！相信大家都有了一定的了解，希望分享的內(nèi)容對大家有所幫助，如果還想學(xué)習(xí)更多知識，歡迎關(guān)注億速云行業(yè)資訊頻道！
免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點(diǎn)不代表本網(wǎng)站立場，如果涉及侵權(quán)請聯(lián)系站長郵箱：is@yisu.com進(jìn)行舉報(bào)，并提供相關(guān)證據(jù)，一經(jīng)查實(shí)，將立刻刪除涉嫌侵權(quán)內(nèi)容。
億速云公眾號
手機(jī)網(wǎng)站二維碼