http://www.sqlservercentral.com/blogs/james-sql-footprint/2012/11/20/explore-file-physical-structure-insert-row-part-1/

Printed 2014/12/18 01:34AM

Explore file physical structure - Insert Row - part 1

By jamesxu98918, 2012/11/20


1. Create sample db
use master
go
CREATE DATABASE [test] ON  PRIMARY
( NAME = N'test', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test.mdf' , SIZE = 3072KB , FILEGROWTH = 1024KB )
 LOG ON
( NAME = N'test_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\master\test_log.ldf' , SIZE = 1024KB , FILEGROWTH = 10%)
GO

2. Create table

use test
GO
BEGIN TRANSACTION
GO
CREATE TABLE dbo.mytest
 (
 a int NOT NULL,
 b varchar(500) NOT NULL,
 d varchar(400) NULL,
 )  ON [PRIMARY]
GO
ALTER TABLE dbo.mytest ADD CONSTRAINT
 PK_mytest PRIMARY KEY CLUSTERED
 (
 a
 ) WITH( STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

GO

COMMIT


3. Insert test data
use test
go
Declare @int int

set @int=1
while (@int <= 10)
begin
if ((@int % 2)=1)
insert into mytest(a,b,d)
values(@int,CONVERT(char(500),@int),CONVERT(char(400),@int))

set @int=@int+1
end


4. select data and check page number

use master
GO
SELECT %%physloc%% rowid, sys.fn_PhysLocFormatter (%%physloc%%) AS [Physical RID],DATALENGTH(a) a_length, DATALENGTH(b) b_length,DATALENGTH(d) d_length, * FROM test.dbo.mytest
GO
output
rowid Physical RID a_length b_length d_length a b d
0x9900000001000000 (1:153:0) 4 500 400 1 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    1                                                                                                                                                                                                                                                                                                                                                                                                               
0x9900000001000100 (1:153:1) 4 500 400 3 3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    3                                                                                                                                                                                                                                                                                                                                                                                                               
0x9900000001000200 (1:153:2) 4 500 400 5 5                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    5                                                                                                                                                                                                                                                                                                                                                                                                               
0x9900000001000300 (1:153:3) 4 500 400 7 7                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    7                                                                                                                                                                                                                                                                                                                                                                                                               
0x9900000001000400 (1:153:4) 4 500 400 9 9                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    9                                                                                                                                                                                                                                                                                                                                                                                                               



so the 5 rows are saved in same page: (1:153)

5. insert a new row

use test
GO
insert into mytest(a,b,d)
values(2,CONVERT(char(500),2),CONVERT(char(400),2))
GO

6. select data

use master
GO
SELECT %%physloc%% rowid, sys.fn_PhysLocFormatter (%%physloc%%) AS [Physical RID],DATALENGTH(a) a_length, DATALENGTH(b) b_length,DATALENGTH(d) d_length, * FROM test.dbo.mytest
GO
rowid Physical RID a_length b_length d_length a b d
0x9900000001000000 (1:153:0) 4 500 400 1 1                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    1                                                                                                                                                                                                                                                                                                                                                                                                               
0x9900000001000100 (1:153:1) 4 500 400 2 2                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    2                                                                                                                                                                                                                                                                                                                                                                                                               
0x9900000001000200 (1:153:2) 4 500 400 3 3                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    3                                                                                                                                                                                                                                                                                                                                                                                                               
0x9900000001000300 (1:153:3) 4 500 400 5 5                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    5                                                                                                                                                                                                                                                                                                                                                                                                               
0x9900000001000400 (1:153:4) 4 500 400 7 7                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    7                                                                                                                                                                                                                                                                                                                                                                                                               
0x9900000001000500 (1:153:5) 4 500 400 9 9                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    9                                                                                                                                                                                                                                                                                                                                                                                                               


now row a=2 has been inserted into table, and the rowid =1.
Does sql server move rows in the page? or just insert the new row at the end of page? let's check page again.

7. check page 153



DBCC TRACEON(3604)
GO
dbcc page(test,1,153,2)
GO


DBCC execution completed. If DBCC printed error messages, contact your system administrator.

PAGE: (1:153)


BUFFER:


BUF @0x0000000086FFBEC0

bpage = 0x0000000086F52000           bhash = 0x0000000000000000           bpageno = (1:153)
bdbid = 16                           breferences = 0                      bcputicks = 0
bsampleCount = 0                     bUse1 = 53553                        bstat = 0xc0000b
blog = 0x59bb79bb                    bnext = 0x0000000000000000        

PAGE HEADER:


Page @0x0000000086F52000

m_pageId = (1:153)                   m_headerVersion = 1                  m_type = 1
m_typeFlagBits = 0x4                 m_level = 0                          m_flagBits = 0x0
m_objId (AllocUnitId.idObj) = 30     m_indexId (AllocUnitId.idInd) = 256
Metadata: AllocUnitId = 72057594039894016                              
Metadata: PartitionId = 72057594038976512                                 Metadata: IndexId = 1
Metadata: ObjectId = 2137058649      m_prevPage = (0:0)                   m_nextPage = (0:0)
pminlen = 8                          m_slotCnt = 6                        m_freeCnt = 2582
m_freeData = 5598                    m_reservedCnt = 0                    m_lsn = (44:220: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:1) = 0x60 MIXED_EXT ALLOCATED   0_PCT_FULL                         DIFF (1:6) = CHANGED
ML (1:7) = NOT MIN_LOGGED          

DATA:


Memory Dump @0x0000000010FBA000

0000000010FBA000:   01010400 00000001 00000000 00000800 ?................
0000000010FBA010:   00000000 00000600 1e000000 160ade15 ?..............T.
0000000010FBA020:   99000000 01000000 2c000000 dc000000 ?........,...ü...
0000000010FBA030:   11000000 00000000 00000000 00000000 ?................
0000000010FBA040:   01000000 00000000 00000000 00000000 ?................
0000000010FBA050:   00000000 00000000 00000000 00000000 ?................
0000000010FBA060:   30000800 01000000 03000002 00050295 ?0..............?
0000000010FBA070:   03312020 20202020 20202020 20202020 ?.1            
0000000010FBA080:   20202020 20202020 20202020 20202020 ?              
0000000010FBA090:   20202020 20202020 20202020 20202020 ?              
0000000010FBA0A0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA0B0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA0C0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA0D0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA0E0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA0F0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA100:   20202020 20202020 20202020 20202020 ?              
0000000010FBA110:   20202020 20202020 20202020 20202020 ?              
0000000010FBA120:   20202020 20202020 20202020 20202020 ?              
0000000010FBA130:   20202020 20202020 20202020 20202020 ?              
0000000010FBA140:   20202020 20202020 20202020 20202020 ?              
0000000010FBA150:   20202020 20202020 20202020 20202020 ?              
0000000010FBA160:   20202020 20202020 20202020 20202020 ?              
0000000010FBA170:   20202020 20202020 20202020 20202020 ?              
0000000010FBA180:   20202020 20202020 20202020 20202020 ?              
0000000010FBA190:   20202020 20202020 20202020 20202020 ?              
0000000010FBA1A0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA1B0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA1C0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA1D0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA1E0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA1F0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA200:   20202020 20202020 20202020 20202020 ?              
0000000010FBA210:   20202020 20202020 20202020 20202020 ?              
0000000010FBA220:   20202020 20202020 20202020 20202020 ?              
0000000010FBA230:   20202020 20202020 20202020 20202020 ?              
0000000010FBA240:   20202020 20202020 20202020 20202020 ?              
0000000010FBA250:   20202020 20202020 20202020 20202020 ?              
0000000010FBA260:   20202020 20312020 20202020 20202020 ?     1        
0000000010FBA270:   20202020 20202020 20202020 20202020 ?              
0000000010FBA280:   20202020 20202020 20202020 20202020 ?              
0000000010FBA290:   20202020 20202020 20202020 20202020 ?              
0000000010FBA2A0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA2B0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA2C0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA2D0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA2E0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA2F0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA300:   20202020 20202020 20202020 20202020 ?              
0000000010FBA310:   20202020 20202020 20202020 20202020 ?              
0000000010FBA320:   20202020 20202020 20202020 20202020 ?              
0000000010FBA330:   20202020 20202020 20202020 20202020 ?              
0000000010FBA340:   20202020 20202020 20202020 20202020 ?              
0000000010FBA350:   20202020 20202020 20202020 20202020 ?              
0000000010FBA360:   20202020 20202020 20202020 20202020 ?              
0000000010FBA370:   20202020 20202020 20202020 20202020 ?              
0000000010FBA380:   20202020 20202020 20202020 20202020 ?              
0000000010FBA390:   20202020 20202020 20202020 20202020 ?              
0000000010FBA3A0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA3B0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA3C0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA3D0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA3E0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA3F0:   20202020 20300008 00030000 00030000 ?     0..........
0000000010FBA400:   02000502 95033320 20202020 20202020 ?....?.3        
0000000010FBA410:   20202020 20202020 20202020 20202020 ?              
0000000010FBA420:   20202020 20202020 20202020 20202020 ?              
0000000010FBA430:   20202020 20202020 20202020 20202020 ?              
0000000010FBA440:   20202020 20202020 20202020 20202020 ?              
0000000010FBA450:   20202020 20202020 20202020 20202020 ?              
0000000010FBA460:   20202020 20202020 20202020 20202020 ?              
0000000010FBA470:   20202020 20202020 20202020 20202020 ?              
0000000010FBA480:   20202020 20202020 20202020 20202020 ?              
0000000010FBA490:   20202020 20202020 20202020 20202020 ?              
0000000010FBA4A0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA4B0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA4C0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA4D0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA4E0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA4F0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA500:   20202020 20202020 20202020 20202020 ?              
0000000010FBA510:   20202020 20202020 20202020 20202020 ?              
0000000010FBA520:   20202020 20202020 20202020 20202020 ?              
0000000010FBA530:   20202020 20202020 20202020 20202020 ?              
0000000010FBA540:   20202020 20202020 20202020 20202020 ?              
0000000010FBA550:   20202020 20202020 20202020 20202020 ?              
0000000010FBA560:   20202020 20202020 20202020 20202020 ?              
0000000010FBA570:   20202020 20202020 20202020 20202020 ?              
0000000010FBA580:   20202020 20202020 20202020 20202020 ?              
0000000010FBA590:   20202020 20202020 20202020 20202020 ?              
0000000010FBA5A0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA5B0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA5C0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA5D0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA5E0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA5F0:   20202020 20202020 20203320 20202020 ?          3    
0000000010FBA600:   20202020 20202020 20202020 20202020 ?              
0000000010FBA610:   20202020 20202020 20202020 20202020 ?              
0000000010FBA620:   20202020 20202020 20202020 20202020 ?              
0000000010FBA630:   20202020 20202020 20202020 20202020 ?              
0000000010FBA640:   20202020 20202020 20202020 20202020 ?              
0000000010FBA650:   20202020 20202020 20202020 20202020 ?              
0000000010FBA660:   20202020 20202020 20202020 20202020 ?              
0000000010FBA670:   20202020 20202020 20202020 20202020 ?              
0000000010FBA680:   20202020 20202020 20202020 20202020 ?              
0000000010FBA690:   20202020 20202020 20202020 20202020 ?              
0000000010FBA6A0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA6B0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA6C0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA6D0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA6E0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA6F0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA700:   20202020 20202020 20202020 20202020 ?              
0000000010FBA710:   20202020 20202020 20202020 20202020 ?              
0000000010FBA720:   20202020 20202020 20202020 20202020 ?              
0000000010FBA730:   20202020 20202020 20202020 20202020 ?              
0000000010FBA740:   20202020 20202020 20202020 20202020 ?              
0000000010FBA750:   20202020 20202020 20202020 20202020 ?              
0000000010FBA760:   20202020 20202020 20202020 20202020 ?              
0000000010FBA770:   20202020 20202020 20202020 20202020 ?              
0000000010FBA780:   20202020 20202020 20203000 08000500 ?          0.....
0000000010FBA790:   00000300 00020005 02950335 20202020 ?.........?.5  
0000000010FBA7A0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA7B0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA7C0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA7D0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA7E0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA7F0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA800:   20202020 20202020 20202020 20202020 ?              
0000000010FBA810:   20202020 20202020 20202020 20202020 ?              
0000000010FBA820:   20202020 20202020 20202020 20202020 ?              
0000000010FBA830:   20202020 20202020 20202020 20202020 ?              
0000000010FBA840:   20202020 20202020 20202020 20202020 ?              
0000000010FBA850:   20202020 20202020 20202020 20202020 ?              
0000000010FBA860:   20202020 20202020 20202020 20202020 ?              
0000000010FBA870:   20202020 20202020 20202020 20202020 ?              
0000000010FBA880:   20202020 20202020 20202020 20202020 ?              
0000000010FBA890:   20202020 20202020 20202020 20202020 ?              
0000000010FBA8A0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA8B0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA8C0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA8D0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA8E0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA8F0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA900:   20202020 20202020 20202020 20202020 ?              
0000000010FBA910:   20202020 20202020 20202020 20202020 ?              
0000000010FBA920:   20202020 20202020 20202020 20202020 ?              
0000000010FBA930:   20202020 20202020 20202020 20202020 ?              
0000000010FBA940:   20202020 20202020 20202020 20202020 ?              
0000000010FBA950:   20202020 20202020 20202020 20202020 ?              
0000000010FBA960:   20202020 20202020 20202020 20202020 ?              
0000000010FBA970:   20202020 20202020 20202020 20202020 ?              
0000000010FBA980:   20202020 20202020 20202020 20202035 ?               5
0000000010FBA990:   20202020 20202020 20202020 20202020 ?              
0000000010FBA9A0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA9B0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA9C0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA9D0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA9E0:   20202020 20202020 20202020 20202020 ?              
0000000010FBA9F0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAA00:   20202020 20202020 20202020 20202020 ?              
0000000010FBAA10:   20202020 20202020 20202020 20202020 ?              
0000000010FBAA20:   20202020 20202020 20202020 20202020 ?              
0000000010FBAA30:   20202020 20202020 20202020 20202020 ?              
0000000010FBAA40:   20202020 20202020 20202020 20202020 ?              
0000000010FBAA50:   20202020 20202020 20202020 20202020 ?              
0000000010FBAA60:   20202020 20202020 20202020 20202020 ?              
0000000010FBAA70:   20202020 20202020 20202020 20202020 ?              
0000000010FBAA80:   20202020 20202020 20202020 20202020 ?              
0000000010FBAA90:   20202020 20202020 20202020 20202020 ?              
0000000010FBAAA0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAAB0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAAC0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAAD0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAAE0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAAF0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAB00:   20202020 20202020 20202020 20202020 ?              
0000000010FBAB10:   20202020 20202020 20202020 20202030 ?               0
0000000010FBAB20:   00080007 00000003 00000200 05029503 ?..............?.
0000000010FBAB30:   37202020 20202020 20202020 20202020 ?7              
0000000010FBAB40:   20202020 20202020 20202020 20202020 ?              
0000000010FBAB50:   20202020 20202020 20202020 20202020 ?              
0000000010FBAB60:   20202020 20202020 20202020 20202020 ?              
0000000010FBAB70:   20202020 20202020 20202020 20202020 ?              
0000000010FBAB80:   20202020 20202020 20202020 20202020 ?              
0000000010FBAB90:   20202020 20202020 20202020 20202020 ?              
0000000010FBABA0:   20202020 20202020 20202020 20202020 ?              
0000000010FBABB0:   20202020 20202020 20202020 20202020 ?              
0000000010FBABC0:   20202020 20202020 20202020 20202020 ?              
0000000010FBABD0:   20202020 20202020 20202020 20202020 ?              
0000000010FBABE0:   20202020 20202020 20202020 20202020 ?              
0000000010FBABF0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAC00:   20202020 20202020 20202020 20202020 ?              
0000000010FBAC10:   20202020 20202020 20202020 20202020 ?              
0000000010FBAC20:   20202020 20202020 20202020 20202020 ?              
0000000010FBAC30:   20202020 20202020 20202020 20202020 ?              
0000000010FBAC40:   20202020 20202020 20202020 20202020 ?              
0000000010FBAC50:   20202020 20202020 20202020 20202020 ?              
0000000010FBAC60:   20202020 20202020 20202020 20202020 ?              
0000000010FBAC70:   20202020 20202020 20202020 20202020 ?              
0000000010FBAC80:   20202020 20202020 20202020 20202020 ?              
0000000010FBAC90:   20202020 20202020 20202020 20202020 ?              
0000000010FBACA0:   20202020 20202020 20202020 20202020 ?              
0000000010FBACB0:   20202020 20202020 20202020 20202020 ?              
0000000010FBACC0:   20202020 20202020 20202020 20202020 ?              
0000000010FBACD0:   20202020 20202020 20202020 20202020 ?              
0000000010FBACE0:   20202020 20202020 20202020 20202020 ?              
0000000010FBACF0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAD00:   20202020 20202020 20202020 20202020 ?              
0000000010FBAD10:   20202020 20202020 20202020 20202020 ?              
0000000010FBAD20:   20202020 37202020 20202020 20202020 ?    7          
0000000010FBAD30:   20202020 20202020 20202020 20202020 ?              
0000000010FBAD40:   20202020 20202020 20202020 20202020 ?              
0000000010FBAD50:   20202020 20202020 20202020 20202020 ?              
0000000010FBAD60:   20202020 20202020 20202020 20202020 ?              
0000000010FBAD70:   20202020 20202020 20202020 20202020 ?              
0000000010FBAD80:   20202020 20202020 20202020 20202020 ?              
0000000010FBAD90:   20202020 20202020 20202020 20202020 ?              
0000000010FBADA0:   20202020 20202020 20202020 20202020 ?              
0000000010FBADB0:   20202020 20202020 20202020 20202020 ?              
0000000010FBADC0:   20202020 20202020 20202020 20202020 ?              
0000000010FBADD0:   20202020 20202020 20202020 20202020 ?              
0000000010FBADE0:   20202020 20202020 20202020 20202020 ?              
0000000010FBADF0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAE00:   20202020 20202020 20202020 20202020 ?              
0000000010FBAE10:   20202020 20202020 20202020 20202020 ?              
0000000010FBAE20:   20202020 20202020 20202020 20202020 ?              
0000000010FBAE30:   20202020 20202020 20202020 20202020 ?              
0000000010FBAE40:   20202020 20202020 20202020 20202020 ?              
0000000010FBAE50:   20202020 20202020 20202020 20202020 ?              
0000000010FBAE60:   20202020 20202020 20202020 20202020 ?              
0000000010FBAE70:   20202020 20202020 20202020 20202020 ?              
0000000010FBAE80:   20202020 20202020 20202020 20202020 ?              
0000000010FBAE90:   20202020 20202020 20202020 20202020 ?              
0000000010FBAEA0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAEB0:   20202020 30000800 09000000 03000002 ?    0... ....... 
0000000010FBAEC0:   00050295 03392020 20202020 20202020 ?...?.9        
0000000010FBAED0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAEE0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAEF0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAF00:   20202020 20202020 20202020 20202020 ?              
0000000010FBAF10:   20202020 20202020 20202020 20202020 ?              
0000000010FBAF20:   20202020 20202020 20202020 20202020 ?              
0000000010FBAF30:   20202020 20202020 20202020 20202020 ?              
0000000010FBAF40:   20202020 20202020 20202020 20202020 ?              
0000000010FBAF50:   20202020 20202020 20202020 20202020 ?              
0000000010FBAF60:   20202020 20202020 20202020 20202020 ?              
0000000010FBAF70:   20202020 20202020 20202020 20202020 ?              
0000000010FBAF80:   20202020 20202020 20202020 20202020 ?              
0000000010FBAF90:   20202020 20202020 20202020 20202020 ?              
0000000010FBAFA0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAFB0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAFC0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAFD0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAFE0:   20202020 20202020 20202020 20202020 ?              
0000000010FBAFF0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB000:   20202020 20202020 20202020 20202020 ?              
0000000010FBB010:   20202020 20202020 20202020 20202020 ?              
0000000010FBB020:   20202020 20202020 20202020 20202020 ?              
0000000010FBB030:   20202020 20202020 20202020 20202020 ?              
0000000010FBB040:   20202020 20202020 20202020 20202020 ?              
0000000010FBB050:   20202020 20202020 20202020 20202020 ?              
0000000010FBB060:   20202020 20202020 20202020 20202020 ?              
0000000010FBB070:   20202020 20202020 20202020 20202020 ?              
0000000010FBB080:   20202020 20202020 20202020 20202020 ?              
0000000010FBB090:   20202020 20202020 20202020 20202020 ?              
0000000010FBB0A0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB0B0:   20202020 20202020 20392020 20202020 ?         9    
0000000010FBB0C0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB0D0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB0E0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB0F0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB100:   20202020 20202020 20202020 20202020 ?              
0000000010FBB110:   20202020 20202020 20202020 20202020 ?              
0000000010FBB120:   20202020 20202020 20202020 20202020 ?              
0000000010FBB130:   20202020 20202020 20202020 20202020 ?              
0000000010FBB140:   20202020 20202020 20202020 20202020 ?              
0000000010FBB150:   20202020 20202020 20202020 20202020 ?              
0000000010FBB160:   20202020 20202020 20202020 20202020 ?              
0000000010FBB170:   20202020 20202020 20202020 20202020 ?              
0000000010FBB180:   20202020 20202020 20202020 20202020 ?              
0000000010FBB190:   20202020 20202020 20202020 20202020 ?              
0000000010FBB1A0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB1B0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB1C0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB1D0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB1E0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB1F0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB200:   20202020 20202020 20202020 20202020 ?              
0000000010FBB210:   20202020 20202020 20202020 20202020 ?              
0000000010FBB220:   20202020 20202020 20202020 20202020 ?              
0000000010FBB230:   20202020 20202020 20202020 20202020 ?              
0000000010FBB240:   20202020 20202020 20300008 00020000 ?         0...... 
0000000010FBB250:   00030000 02000502 95033220 20202020 ?........?.2    
0000000010FBB260:   20202020 20202020 20202020 20202020 ?              
0000000010FBB270:   20202020 20202020 20202020 20202020 ?              
0000000010FBB280:   20202020 20202020 20202020 20202020 ?              
0000000010FBB290:   20202020 20202020 20202020 20202020 ?              
0000000010FBB2A0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB2B0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB2C0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB2D0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB2E0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB2F0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB300:   20202020 20202020 20202020 20202020 ?              
0000000010FBB310:   20202020 20202020 20202020 20202020 ?              
0000000010FBB320:   20202020 20202020 20202020 20202020 ?              
0000000010FBB330:   20202020 20202020 20202020 20202020 ?              
0000000010FBB340:   20202020 20202020 20202020 20202020 ?              
0000000010FBB350:   20202020 20202020 20202020 20202020 ?              
0000000010FBB360:   20202020 20202020 20202020 20202020 ?              
0000000010FBB370:   20202020 20202020 20202020 20202020 ?              
0000000010FBB380:   20202020 20202020 20202020 20202020 ?              
0000000010FBB390:   20202020 20202020 20202020 20202020 ?              
0000000010FBB3A0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB3B0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB3C0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB3D0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB3E0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB3F0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB400:   20202020 20202020 20202020 20202020 ?              
0000000010FBB410:   20202020 20202020 20202020 20202020 ?              
0000000010FBB420:   20202020 20202020 20202020 20202020 ?              
0000000010FBB430:   20202020 20202020 20202020 20202020 ?              
0000000010FBB440:   20202020 20202020 20202020 20203220 ?              2
0000000010FBB450:   20202020 20202020 20202020 20202020 ?              
0000000010FBB460:   20202020 20202020 20202020 20202020 ?              
0000000010FBB470:   20202020 20202020 20202020 20202020 ?              
0000000010FBB480:   20202020 20202020 20202020 20202020 ?              
0000000010FBB490:   20202020 20202020 20202020 20202020 ?              
0000000010FBB4A0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB4B0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB4C0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB4D0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB4E0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB4F0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB500:   20202020 20202020 20202020 20202020 ?              
0000000010FBB510:   20202020 20202020 20202020 20202020 ?              
0000000010FBB520:   20202020 20202020 20202020 20202020 ?              
0000000010FBB530:   20202020 20202020 20202020 20202020 ?              
0000000010FBB540:   20202020 20202020 20202020 20202020 ?              
0000000010FBB550:   20202020 20202020 20202020 20202020 ?              
0000000010FBB560:   20202020 20202020 20202020 20202020 ?              
0000000010FBB570:   20202020 20202020 20202020 20202020 ?              
0000000010FBB580:   20202020 20202020 20202020 20202020 ?              
0000000010FBB590:   20202020 20202020 20202020 20202020 ?              
0000000010FBB5A0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB5B0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB5C0:   20202020 20202020 20202020 20202020 ?              
0000000010FBB5D0:   20202020 20202020 20202020 20200000 ?              ..
0000000010FBB5E0:   03000000 38380000 0004000a 00000000 ?....88..........
0000000010FBB5F0:   00010000 00040000 00000000 00000000 ?................
0000000010FBB600:   00000010 00008001 00450070 006c0061 ?.........E.p.l.a
0000000010FBB610:   00630065 00640069 00640030 002d005d ?.c.e.d.i.d.0.-.]
0000000010FBB620:   00000000 00040000 00383800 00000400 ?.........88.....
0000000010FBB630:   0a000000 00000100 00000400 00000000 ?................
0000000010FBB640:   00000000 00000000 10000080 01004100 ?..............A.
0000000010FBB650:   73007400 61007400 75007300 30002d00 ?s.t.a.t.u.s.0.-.
0000000010FBB660:   5d000000 00000500 00003838 00000004 ?].........88....
0000000010FBB670:   000a0000 00000001 00000004 00000000 ?................
0000000010FBB680:   00000000 00000000 00100000 80010045 ?...............E
0000000010FBB690:   006d0069 006e006f 00630063 00750072 ?.m.i.n.o.c.c.u.r
0000000010FBB6A0:   0030002d 005d0000 00000006 00000038 ?.0.-.].........8
0000000010FBB6B0:   38000000 04000a00 00000000 01000000 ?8...............
0000000010FBB6C0:   04000000 00000000 00000000 00001000 ?................
0000000010FBB6D0:   00800100 45006d00 61007800 6f006300 ?....E.m.a.x.o.c.
0000000010FBB6E0:   63007500 72003000 2d005d00 00000000 ?c.u.r.0.-.].....
0000000010FBB6F0:   07000000 e7e70000 00401f00 00080001 ?....??...@......
0000000010FBB700:   00020000 00401f00 00000000 00000000 ?.....@..........
0000000010FBB710:   00000010 00008001 00410064 00650066 ?.........A.d.e.f
0000000010FBB720:   00760061 006c0030 002d0061 00000000 ?.v.a.l.0.-.a....
0000000010FBB730:   00010000 00303000 00000100 03000000 ?.....00.........
0000000010FBB740:   00000100 00000100 00000000 00000000 ?................
0000000010FBB750:   00000000 10000080 01003f00 63006c00 ?..........?.c.l.
0000000010FBB760:   61007300 73003000 2d006100 00000000 ?a.s.s.0.-.a.....
0000000010FBB770:   02000000 38380000 0004000a 00000000 ?....88..........
0000000010FBB780:   00010000 00040000 00000000 00000000 ?................
0000000010FBB790:   00000010 00008001 00430069 0064006d ?.........C.i.d.m
0000000010FBB7A0:   0061006a 006f0072 0030002d 00610000 ?.a.j.o.r.0.-.a..
0000000010FBB7B0:   00000003 00000038 38000000 04000a00 ?.......88.......
0000000010FBB7C0:   00000000 01000000 04000000 00000000 ?................
0000000010FBB7D0:   00000000 00001000 00800100 3f007300 ?............?.s.
0000000010FBB7E0:   75006200 69006400 30002d00 61000000 ?u.b.i.d.0.-.a...
0000000010FBB7F0:   00000400 0000e700 01000000 01000008 ?......?.........
0000000010FBB800:   00010003 00000000 01000000 00000000 ?................
0000000010FBB810:   00000000 00100000 8001003d 006e0061 ?...........=.n.a
0000000010FBB820:   006d0065 0030002d 00610000 00000005 ?.m.e.0.-.a......
0000000010FBB830:   00000038 38000000 04000a00 00000000 ?...88...........
0000000010FBB840:   01000000 04000000 00000000 00000000 ?................
0000000010FBB850:   00001000 00800100 41007300 74006100 ?........A.s.t.a.
0000000010FBB860:   74007500 73003000 2d006100 00000000 ?t.u.s.0.-.a.....
0000000010FBB870:   06000000 38380000 0004000a 00000000 ?....88..........
0000000010FBB880:   00010000 00040000 00000000 00000000 ?................
0000000010FBB890:   00000010 00008001 00430069 006e0074 ?.........C.i.n.t
0000000010FBB8A0:   00700072 006f0070 0030002d 00480000 ?.p.r.o.p.0.-.H..
0000000010FBB8B0:   00000001 00000024 24000000 10000000 ?.......$$.......
0000000010FBB8C0:   00000000 01000000 10000000 00000000 ?................
0000000010FBB8D0:   00000000 00001000 00800100 41006800 ?............A.h.
0000000010FBB8E0:   61006e00 64006c00 65003000 2d004800 ?a.n.d.l.e.0.-.H.
0000000010FBB8F0:   00000000 02000000 24240000 00100000 ?........$$......
0000000010FBB900:   00000000 00010000 00100000 00000000 ?................
0000000010FBB910:   00000000 00000010 00008001 00410064 ?.............A.d
0000000010FBB920:   00690061 00670069 00640030 002d0048 ?.i.a.g.i.d.0.-.H
0000000010FBB930:   00000000 00030000 00303000 00000100 ?.........00.....
0000000010FBB940:   03000000 00000100 00000100 00000000 ?................
0000000010FBB950:   00000000 00000000 10000080 01004700 ?..............G.
0000000010FBB960:   69006e00 69007400 69006100 74006f00 ?i.n.i.t.i.a.t.o.
0000000010FBB970:   72003000 2d004800 00000000 04000000 ?r.0.-.H.........
0000000010FBB980:   7f7f0000 00080013 00000000 00010000 ?................
0000000010FBB990:   00080000 00000000 00000000 00000010 ?................
0000000010FBB9A0:   00008001 00430073 0065006e 00640073 ?.....C.s.e.n.d.s
0000000010FBB9B0:   00650071 0030002d 00480000 00000005 ?.e.q.0.-.H......
0000000010FBB9C0:   000000ad ad000000 06000000 00000000 ?...--...........
0000000010FBB9D0:   03000000 06000000 00000000 00000000 ?................
0000000010FBB9E0:   00001000 00800100 45007300 65006e00 ?........E.s.e.n.
0000000010FBB9F0:   64007800 61006300 74003000 2d004900 ?d.x.a.c.t.0.-.I.
0000000010FBBA00:   00000000 01000000 24240000 00100000 ?........$$......
0000000010FBBA10:   00000000 00010000 00100000 00000000 ?................
0000000010FBBA20:   00000000 00000010 00008001 00410064 ?.............A.d
0000000010FBBA30:   00690061 00670069 00640030 002d0049 ?.i.a.g.i.d.0.-.I
0000000010FBBA40:   00000000 00020000 00303000 00000100 ?.........00.....
0000000010FBBA50:   03000000 00000100 00000100 00000000 ?................
0000000010FBBA60:   00000000 00000000 10000080 01004700 ?..............G.
0000000010FBBA70:   69006e00 69007400 69006100 74006f00 ?i.n.i.t.i.a.t.o.
0000000010FBBA80:   72003000 2d004900 00000000 03000000 ?r.0.-.I.........
0000000010FBBA90:   24240000 00100000 00000000 00010000 ?$$..............
0000000010FBBAA0:   00100000 00000000 00000000 00000010 ?................
0000000010FBBAB0:   00008001 00410068 0061006e 0064006c ?.....A.h.a.n.d.l
0000000010FBBAC0:   00650030 002d0049 00000000 00040000 ?.e.0.-.I........
0000000010FBBAD0:   007f7f00 00000800 13000000 00000100 ?................
0000000010FBBAE0:   00000800 00000000 00000000 00000000 ?................
0000000010FBBAF0:   10000080 01004100 72006300 76007300 ?......A.r.c.v.s.
0000000010FBBB00:   65007100 30002d00 49000000 00000500 ?e.q.0.-.I.......
0000000010FBBB10:   00003838 00000004 000a0000 00000001 ?..88............
0000000010FBBB20:   00000004 00000000 00000000 00000000 ?................
0000000010FBBB30:   00100000 80010043 00720063 00760066 ?.......C.r.c.v.f
0000000010FBBB40:   00720061 00670030 002d0049 00000000 ?.r.a.g.0.-.I....
0000000010FBBB50:   00060000 00383800 00000400 0a000000 ?.....88.........
0000000010FBBB60:   00000100 00000400 00000000 00000000 ?................
0000000010FBBB70:   00000000 10000080 01004100 73007400 ?..........A.s.t.
0000000010FBBB80:   61007400 75007300 30002d00 49000000 ?a.t.u.s.0.-.I...
0000000010FBBB90:   00000700 0000afaf 00000002 00000008 ?......¯¯........
0000000010FBBBA0:   10000003 00000002 00000000 00000000 ?................
0000000010FBBBB0:   00000000 00100000 8001003f 00730074 ?...........?.s.t
0000000010FBBBC0:   00610074 00650030 002d0049 00000000 ?.a.t.e.0.-.I....
0000000010FBBBD0:   00080000 003d3d00 00000800 17030000 ?.....==.........
0000000010FBBBE0:   00000100 00000800 00000000 00000000 ?................
0000000010FBBBF0:   00000000 10000080 01004500 6c006900 ?..........E.l.i.
0000000010FBBC00:   66006500 74006900 6d006500 30002d00 ?f.e.t.i.m.e.0.-.
0000000010FBBC10:   49000000 00000900 00003838 00000004 ?I..... ...88....
0000000010FBBC20:   000a0000 00000001 00000004 00000000 ?................
0000000010FBBC30:   00000000 00000000 00100000 80010045 ?...............E
0000000010FBBC40:   0063006f 006e0074 00720061 00630074 ?.c.o.n.t.r.a.c.t
0000000010FBBC50:   0030002d 00490000 0000000a 00000038 ?.0.-.I.........8
0000000010FBBC60:   38000000 04000a00 00000000 01000000 ?8...............
0000000010FBBC70:   04000000 00000000 00000000 00001000 ?................
0000000010FBBC80:   00800100 3f007300 76006300 69006400 ?....?.s.v.c.i.d.
0000000010FBBC90:   30002d00 49000000 00000b00 00002424 ?0.-.I.........$$
0000000010FBBCA0:   00000010 00000000 00000001 00000010 ?................
0000000010FBBCB0:   00000000 00000000 00000000 00100000 ?................
0000000010FBBCC0:   80010047 0063006f 006e0076 00670072 ?...G.c.o.n.v.g.r
0000000010FBBCD0:   006f0075 00700030 002d0049 00000000 ?.o.u.p.0.-.I....
0000000010FBBCE0:   000c0000 007f7f00 00000800 13000000 ?................
0000000010FBBCF0:   00000100 00000800 00000000 00000000 ?................
0000000010FBBD00:   00000000 10000080 01004100 73007900 ?..........A.s.y.
0000000010FBBD10:   73007300 65007100 30002d00 49000000 ?s.s.e.q.0.-.I...
0000000010FBBD20:   00000d00 00007f7f 00000008 00130000 ?................
0000000010FBBD30:   00000001 00000008 00000000 00000000 ?................
0000000010FBBD40:   00000000 00100000 80010047 0065006e ?...........G.e.n
0000000010FBBD50:   00640064 006c0067 00730065 00710030 ?.d.d.l.g.s.e.q.0
0000000010FBBD60:   002d0049 00000000 000e0000 007f7f00 ?.-.I............
0000000010FBBD70:   00000800 13000000 00000100 00000800 ?................
0000000010FBBD80:   00000000 00000000 00000000 10000080 ?................
0000000010FBBD90:   01004b00 66006900 72007300 74006f00 ?..K.f.i.r.s.t.o.
0000000010FBBDA0:   6f007200 64006500 72003000 2d004900 ?o.r.d.e.r.0.-.I.
0000000010FBBDB0:   00000000 0f000000 7f7f0000 00080013 ?................
0000000010FBBDC0:   00000000 00010000 00080000 00000000 ?................
0000000010FBBDD0:   00000000 00000010 00008001 0049006c ?.............I.l
0000000010FBBDE0:   00610073 0074006f 006f0072 00640065 ?.a.s.t.o.o.r.d.e
0000000010FBBDF0:   00720030 002d0049 00000000 00100000 ?.r.0.-.I........
0000000010FBBE00:   00383800 00000400 0a000000 00000100 ?.88.............
0000000010FBBE10:   00000400 00000000 00000000 00000000 ?................
0000000010FBBE20:   10000080 01004d00 6c006100 73007400 ?......M.l.a.s.t.
0000000010FBBE30:   6f006f00 72006400 65007200 66007200 ?o.o.r.d.e.r.f.r.
0000000010FBBE40:   30002d00 49000000 00001100 00003d3d ?0.-.I.........==
0000000010FBBE50:   00000008 00170300 00000001 00000008 ?................
0000000010FBBE60:   00000000 00000000 00000000 00100000 ?................
0000000010FBBE70:   80010045 0064006c 00670074 0069006d ?...E.d.l.g.t.i.m
0000000010FBBE80:   00650072 0030002d 00490000 00000012 ?.e.r.0.-.I......
0000000010FBBE90:   0000003d 3d000000 08001703 00000000 ?...==...........
0000000010FBBEA0:   01000000 08000000 00000000 00000000 ?................
0000000010FBBEB0:   00001000 00800100 47006400 6c006700 ?........G.d.l.g.
0000000010FBBEC0:   6f007000 65006e00 65006400 30002d00 ?o.p.e.n.e.d.0.-.
0000000010FBBED0:   49000000 00001300 00003838 00000004 ?I.........88....
0000000010FBBEE0:   000a0000 00000001 00000004 00000000 ?................
0000000010FBBEF0:   00000000 00000000 00100000 80010043 ?...............C
0000000010FBBF00:   00700072 0069006e 00630069 00640030 ?.p.r.i.n.c.i.d.0
0000000010FBBF10:   002d0049 00000000 00140000 00a5a500 ?.-.I.........??.
0000000010FBBF20:   00003800 00000000 00000300 00003800 ?..8...........8.
0000000010FBBF30:   00000000 00000000 00000000 10000080 ?................
0000000010FBBF40:   01004700 6f007500 74007300 65007300 ?..G.o.u.t.s.e.s.
0000000010FBBF50:   6b006500 79003000 2d004900 00000000 ?k.e.y.0.-.I.....
0000000010FBBF60:   15000000 24240000 00100000 00000000 ?....$$..........
0000000010FBBF70:   00010000 00100000 00000000 00000000 ?................
0000000010FBBF80:   00000010 00008001 004b006f 00750074 ?.........K.o.u.t
0000000010FBBF90:   00730065 0073006b 00650079 00690064 ?.s.e.s.k.e.y.i.d
0000000010FBBFA0:   00000006 bf057c05 3705840b 390bf80a ?....?.|.7.?.9.?.
0000000010FBBFB0:   af0a6a0a 210ad609 8f094c09 0509c008 ?¯.j.!.? . L . à.
0000000010FBBFC0:   73082a08 df079807 57071007 d1068c06 ?s.*.?...W...?.?.
0000000010FBBFD0:   47060806 c7058405 43050205 bb047a04 ?G...?.?.C...?.z.
0000000010FBBFE0:   3504f203 ab036a03 2903e402 a3025a02 ?5.ò.?.j.).?.?.Z.
0000000010FBBFF0:   2102dc01 b40e1f0b 8a07f503 49126000 ?!.ü.'...?.?.I.`.

OFFSET TABLE:

Row - Offset                      
5 (0x5) - 3764 (0xeb4)            
4 (0x4) - 2847 (0xb1f)            
3 (0x3) - 1930 (0x78a)            
2 (0x2) - 1013 (0x3f5)            
1 (0x1) - 4681 (0x1249)    
0 (0x0) - 96 (0x60)                


DBCC execution completed. If DBCC printed error messages, contact your system administrator.

Based on the output of dbcc page. the new row was inserted at the tail of page. it is sorted order in the page, even  if it is clustered index. However, the offset table is sorted. so the only data move operation occur in the offset table. 




Copyright © 2002-2014 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.