Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

James' SQL Footprint

Love SQL Server, Love life.

Explore file physical structure - variable length row

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 <= 8)
begin
if ((@int % 2)=1)
insert into mytest(a,b,d)
values(@int,CONVERT(char(10),@int),CONVERT(char(10),@int))
else
insert into mytest(a,b,d)
values(@int,CONVERT(char(10),@int),null)
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 10 10 1 1 1
0x9900000001000100 (1:153:1) 4 10 NULL 2 2 NULL
0x9900000001000200 (1:153:2) 4 10 10 3 3 3
0x9900000001000300 (1:153:3) 4 10 NULL 4 4 NULL
0x9900000001000400 (1:153:4) 4 10 10 5 5 5
0x9900000001000500 (1:153:5) 4 10 NULL 6 6 NULL
0x9900000001000600 (1:153:6) 4 10 10 7 7 7
0x9900000001000700 (1:153:7) 4 10 NULL 8 8 NULL


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

5. check page (1:153)

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

the output and comment


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

PAGE: (1:153)


BUFFER:


BUF @0x0000000081FE17C0

bpage = 0x0000000081AEA000           bhash = 0x0000000000000000           bpageno = (1:153)
bdbid = 16                           breferences = 0                      bcputicks = 0
bsampleCount = 0                     bUse1 = 41021                        bstat = 0xc0010b
blog = 0xca2159bb                    bnext = 0x0000000000000000        

PAGE HEADER:


Page @0x0000000081AEA000

m_pageId = (1:153)                   m_headerVersion = 1                  m_type = 1
#m_type:(http://www.sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Anatomy-of-a-page.aspx)
#1 - data page. This holds data records in a heap or clustered index leaf-level.
#2 - index page. This holds index records in the upper levels of a clustered index and all levels of non-clustered indexes.
#3 - text mix page. A text page that holds small chunks of LOB values plus internal parts of text tree. These can be shared between LOB values in the same partition of an index or heap.
#4 - text tree page. A text page that holds large chunks of LOB values from a single column value.
#7 - sort page. A page that stores intermediate results during a sort operation.
#8 - GAM page. Holds global allocation information about extents in a GAM interval (every data file is split into 4GB chunks - the number of extents that can be represented in a bitmap on a single database page). Basically whether an extent is allocated or not. GAM = Global Allocation Map. The first one is page 2 in each file. More on these in a later post.
#9 - SGAM page. Holds global allocation information about extents in a GAM interval. Basically whether an extent is available for allocating mixed-pages. SGAM = Shared GAM. the first one is page 3 in each file. More on these in a later post.
#10 - IAM page. Holds allocation information about which extents within a GAM interval are allocated to an index or allocation unit, in SQL Server 2000 and 2005 respectively. IAM = Index Allocation Map. More on these in a later post.
#11 - PFS page. Holds allocation and free space information about pages within a PFS interval (every data file is also split into approx 64MB chunks - the number of pages that can be represented in a byte-map on a single database page. PFS = Page Free Space. The first one is page 1 in each file. More on these in a later post.
#13 - boot page. Holds information about the database. There's only one of these in the database. It's page 9 in file 1.
#15 - file header page. Holds information about the file. There's one per file and it's page 0 in the file.
#16 - diff map page. Holds information about which extents in a GAM interval have changed since the last full or differential backup. The first one is page 6 in each file.
#17 - ML map page. Holds information about which extents in a GAM interval have changed while in bulk-logged mode since the last backup. This is what allows you to switch to bulk-logged mode for bulk-loads and index rebuilds without worrying about breaking a backup chain. The first one is page 7 in each file.
#20 -  This check for page type 20 was introduced in 9.00.3239 and is present in both SQL 2005 and SQL 2008. Normally these pages are allocated during Online Indexing operations and Bulk Inserts

m_typeFlagBits = 0x4                 m_level = 0                          m_flagBits = 0x8000
#m_typeFlagBits: For data and index pages it will always be 4. For all other pages it will always be 0 - except PFS pages. If a PFS page has m_typeFlagBits of 1, that means that at least one of the pages in the PFS interval mapped by the PFS page has at least one ghost record.
#m_level:For all page types apart from index pages, the level is always 0.

m_objId (AllocUnitId.idObj) = 28     m_indexId (AllocUnitId.idInd) = 256
Metadata: AllocUnitId = 72057594039762944                              
Metadata: PartitionId = 72057594038845440                                 Metadata: IndexId = 1
Metadata: ObjectId = 2105058535      m_prevPage = (0:0)                   m_nextPage = (0:0)
pminlen = 8                          m_slotCnt = 8                        m_freeCnt = 7832
#pminlen :This is the size of the fixed-length portion of the records on the page. here we have ony 1 fixed length column a(int, 4bytes)+row header 4 bytes=8 bytes
#m_slotCnt: This is the count of records on the page. 8 records in tihs page
#m_freeCnt=Page size(8192) -page header size(96)-odd row size(37)*4-even row size(25)*4-offset table at the tail of page(row count(8)*2bytes)=7832

m_freeData = 344                     m_reservedCnt = 0                    m_lsn = (28:80: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:1) = 0x60 MIXED_EXT ALLOCATED   0_PCT_FULL                         DIFF (1:6) = CHANGED
ML (1:7) = NOT MIN_LOGGED          

DATA:


Memory Dump @0x00000000107CC000

00000000107CC000:   01010400 00800001 00000000 00000800 †................
00000000107CC010:   00000000 00000800 1c000000 981e5801 †..............X.
00000000107CC020:   99000000 01000000 1c000000 50000000 †............P...
00000000107CC030:   02000000 00000000 00000000 00000000 †................
00000000107CC040:   01000000 00000000 00000000 00000000 †................
00000000107CC050:   00000000 00000000 00000000 00000000 †................
#first 96 bytes are page header

00000000107CC060:   30000800 01000000 03000002 001b0025 †0..............%
#4bytres row head 30000800
#first byte "30": The first byte is a status byte that contains info on how to parse the row contents. The value 0x10 defines the inclusion of a NULL_BITMAP, as indicated by the record attributes.
#more info: Bit 4(0x10) means the record has a NULL bitmap and bit 5(0x20) means the record has variable length columns. If 0x40 (bit 6) was also set, that would indicate that the record has a versioning tag. If 0x80 (bit 7) was also set, that would indicate that byte 1 has a value in it.
#so here 0x30 means the row has NULL Bitmap and Virable length column.
#Bits 1-3 of byte 0 give the record type. The possible values are:
#0 = primary record. A data record in a heap that hasn't been forwarded or a data record at the leaf level of a clustered index.
#1 = forwarded record
#2 = forwarding record
#3 = index record
#4 = blob fragment
#5 = ghost index record
#6 = ghost data record
#7 = ghost version record. A special 15-byte record containing a single byte record header plus a 14-byte versioning tag that is used in some circumstances (like ghosting a versioned blob record)
#second byte "00":is the TagB byte of the record metadata. It can either be 0x00 or 0x01. If it is 0x01, that means the record type is ghost forwarded record. In this case its 0x00, which is what we expect given the TagA byte value.
#Third, Fourth "0800": are the offset of the NULL bitmap in the record. This is 0x0008 (DBCC PAGE presents multi-byte values in hex dumps as least-significant byte first). This means that there's a 4-byte fixed length portion of the record starting at byte 4.
#the next 4 bytes "01000000":  is the fixed length portion(column a int)
#the next 2 bytes "0300" => 0x0003 is the column count, here we have 3 column.
#the next byte "00" is NULL bitmap, because there is no null column in the first row, so it is 0x00.
#the next 2 bytes "02 00"  are the count of variable length columns in the record. That value is 0x0002 which means we have 2 variable length columns.
#so the next 4 bytes are 2 offset of the 2 variable length colunm:
#first variable length column end offset : "1b00" => 0x001b= 27
#second variable length column end offset : "2500" => 0x0025= 37

00000000107CC070:   00312020 20202020 20202031 20202020 †.1         1  
#the column b is from #17 byte "31" to #26 byte, so the end offset is 27

00000000107CC080:   20202020 20300008 00020000 00030004 †     0..........
#the column d is from #27 byte to #36 byte, so the end offset is 37
#row 1 is end.
#so for odd row, the row length is row header(4 bytes) + fixed row a length(int 4 bytes) + row count(2 bytes) + Null bitmap(1 bytes) +variable length column count(2 bytes) + variable length column end offset(column count * 2=4bytes) + variable length column (here we have 2 columns * column length 10=20 bytes)=37 bytes

#the next 4 bytes "300008 00" is the row header of row 2
#next 4 bytes "020000 00" are value of the first int column a
#the next 2 bytes "0300" => 0x0003 is the column count, here we have 3 column.
#the next byte "04" is NULL bitmap, 0x04=0000 0100, so column a and b are not null, column c are null.

00000000107CC090:   01001900 32202020 20202020 20203000 †....2         0.
#the first 2 bytes "01 00"=>0x0001 means there is only 1 variable length column=> column b
#the next 2 bytes "19 00"=>0x0019=25, so the column b end offset is 25
##row 2 is end.
#so for even row, the row length is row header(4 bytes) + fixed row a length(int 4 bytes) + row count(2 bytes) + Null bitmap(1 bytes) +variable length column count(2 bytes) + variable length column end offset(column count * 1=2bytes) + variable length column (here we have 1 column * column length 10=10 bytes)=25 bytes


00000000107CC0A0:   08000300 00000300 0002001b 00250033 †.............%.3
00000000107CC0B0:   20202020 20202020 20332020 20202020 †         3    
00000000107CC0C0:   20202030 00080004 00000003 00040100 †   0............
00000000107CC0D0:   19003420 20202020 20202020 30000800 †..4         0...
00000000107CC0E0:   05000000 03000002 001b0025 00352020 †...........%.5
00000000107CC0F0:   20202020 20202035 20202020 20202020 †       5      
00000000107CC100:   20300008 00060000 00030004 01001900 † 0..............
00000000107CC110:   36202020 20202020 20203000 08000700 †6         0.....
00000000107CC120:   00000300 0002001b 00250037 20202020 †.........%.7  
00000000107CC130:   20202020 20372020 20202020 20202030 †     7         0
00000000107CC140:   00080008 00000003 00040100 19003820 †..............8
00000000107CC150:   20202020 20202020 00007400 30002d00 †        ..t.0.-.
00000000107CC160:   45000000 00000500 0000e7e7 00000000 †E.........çç....
00000000107CC170:   02000008 00010002 00000000 02000000 †................
00000000107CC180:   00000000 00000000 00100000 8001003d †...............=
00000000107CC190:   00610064 00640072 0030002d 00450000 †.a.d.d.r.0.-.E..
00000000107CC1A0:   00000006 000000e7 e7000000 00020000 †.......çç.......
00000000107CC1B0:   08000100 02000000 00020000 00000000 †................
00000000107CC1C0:   00000000 00001000 00800100 43006d00 †............C.m.
00000000107CC1D0:   69007200 61006400 64007200 30002d00 †i.r.a.d.d.r.0.-.
00000000107CC1E0:   45000000 00000700 00003d3d 00000008 †E.........==....
00000000107CC1F0:   00170300 00000000 00000008 00000000 †................
00000000107CC200:   00000000 00000000 00100000 80010045 †...............E
00000000107CC210:   006c0069 00660065 00740069 006d0065 †.l.i.f.e.t.i.m.e
00000000107CC220:   0030002d 00470000 00000001 00000024 †.0.-.G.........$
00000000107CC230:   24000000 10000000 00000000 01000000 †$...............
00000000107CC240:   10000000 00000000 00000000 00001000 †................
00000000107CC250:   00800100 39006900 64003000 2d004700 †....9.i.d.0.-.G.
00000000107CC260:   00000000 02000000 38380000 0004000a †........88......
00000000107CC270:   00000000 00010000 00040000 00000000 †................
00000000107CC280:   00000000 00000010 00008001 00490073 †.............I.s
00000000107CC290:   00650072 00760069 00630065 005f0069 †.e.r.v.i.c.e._.i
00000000107CC2A0:   00640030 002d0047 00000000 00030000 †.d.0.-.G........
00000000107CC2B0:   00383800 00000400 0a000000 00000100 †.88.............
00000000107CC2C0:   00000400 00000000 00000000 00000000 †................
00000000107CC2D0:   10000080 01004100 73007400 61007400 †......A.s.t.a.t.
00000000107CC2E0:   75007300 30002d00 47000000 00000400 †u.s.0.-.G.......
00000000107CC2F0:   00003838 00000004 000a0000 00000001 †..88............
00000000107CC300:   00000004 00000000 00000000 00000000 †................
00000000107CC310:   00100000 80010045 00720065 00660063 †.......E.r.e.f.c
00000000107CC320:   006f0075 006e0074 0030002d 00480000 †.o.u.n.t.0.-.H..
00000000107CC330:   00000001 00000024 24000000 10000000 †.......$$.......
00000000107CC340:   00000000 01000000 10000000 00000000 †................
00000000107CC350:   00000000 00001000 00800100 41006800 †............A.h.
00000000107CC360:   61006e00 64006c00 65003000 2d004800 †a.n.d.l.e.0.-.H.
00000000107CC370:   00000000 02000000 24240000 00100000 †........$$......
00000000107CC380:   00000000 00010000 00100000 00000000 †................
00000000107CC390:   00000000 00000010 00008001 00410064 †.............A.d
00000000107CC3A0:   00690061 00670069 00640030 002d0048 †.i.a.g.i.d.0.-.H
00000000107CC3B0:   00000000 00030000 00303000 00000100 †.........00.....
00000000107CC3C0:   03000000 00000100 00000100 00000000 †................
00000000107CC3D0:   00000000 00000000 10000080 01004700 †..............G.
00000000107CC3E0:   69006e00 69007400 69006100 74006f00 †i.n.i.t.i.a.t.o.
00000000107CC3F0:   72003000 2d004800 00000000 04000000 †r.0.-.H.........
00000000107CC400:   7f7f0000 00080013 00000000 00010000 †................
00000000107CC410:   00080000 00000000 00000000 00000010 †................
00000000107CC420:   00008001 00430073 0065006e 00640073 †.....C.s.e.n.d.s
00000000107CC430:   00650071 0030002d 00480000 00000005 †.e.q.0.-.H......
00000000107CC440:   000000ad ad000000 06000000 00000000 †...­­...........
00000000107CC450:   03000000 06000000 00000000 00000000 †................
00000000107CC460:   00001000 00800100 45007300 65006e00 †........E.s.e.n.
00000000107CC470:   64007800 61006300 74003000 2d004900 †d.x.a.c.t.0.-.I.
00000000107CC480:   00000000 01000000 24240000 00100000 †........$$......
00000000107CC490:   00000000 00010000 00100000 00000000 †................
00000000107CC4A0:   00000000 00000010 00008001 00410064 †.............A.d
00000000107CC4B0:   00690061 00670069 00640030 002d0049 †.i.a.g.i.d.0.-.I
00000000107CC4C0:   00000000 00020000 00303000 00000100 †.........00.....
00000000107CC4D0:   03000000 00000100 00000100 00000000 †................
00000000107CC4E0:   00000000 00000000 10000080 01004700 †..............G.
00000000107CC4F0:   69006e00 69007400 69006100 74006f00 †i.n.i.t.i.a.t.o.
00000000107CC500:   72003000 2d004900 00000000 03000000 †r.0.-.I.........
00000000107CC510:   24240000 00100000 00000000 00010000 †$$..............
00000000107CC520:   00100000 00000000 00000000 00000010 †................
00000000107CC530:   00008001 00410068 0061006e 0064006c †.....A.h.a.n.d.l
00000000107CC540:   00650030 002d0049 00000000 00040000 †.e.0.-.I........
00000000107CC550:   007f7f00 00000800 13000000 00000100 †................
00000000107CC560:   00000800 00000000 00000000 00000000 †................
00000000107CC570:   10000080 01004100 72006300 76007300 †......A.r.c.v.s.
00000000107CC580:   65007100 30002d00 49000000 00000500 †e.q.0.-.I.......
00000000107CC590:   00003838 00000004 000a0000 00000001 †..88............
00000000107CC5A0:   00000004 00000000 00000000 00000000 †................
00000000107CC5B0:   00100000 80010043 00720063 00760066 †.......C.r.c.v.f
00000000107CC5C0:   00720061 00670030 002d0049 00000000 †.r.a.g.0.-.I....
00000000107CC5D0:   00060000 00383800 00000400 0a000000 †.....88.........
00000000107CC5E0:   00000100 00000400 00000000 00000000 †................
00000000107CC5F0:   00000000 10000080 01004100 73007400 †..........A.s.t.
00000000107CC600:   61007400 75007300 30002d00 49000000 †a.t.u.s.0.-.I...
00000000107CC610:   00000700 0000afaf 00000002 00000008 †......¯¯........
00000000107CC620:   10000003 00000002 00000000 00000000 †................
00000000107CC630:   00000000 00100000 8001003f 00730074 †...........?.s.t
00000000107CC640:   00610074 00650030 002d0049 00000000 †.a.t.e.0.-.I....
00000000107CC650:   00080000 003d3d00 00000800 17030000 †.....==.........
00000000107CC660:   00000100 00000800 00000000 00000000 †................
00000000107CC670:   00000000 10000080 01004500 6c006900 †..........E.l.i.
00000000107CC680:   66006500 74006900 6d006500 30002d00 †f.e.t.i.m.e.0.-.
00000000107CC690:   49000000 00000900 00003838 00000004 †I..... ...88....
00000000107CC6A0:   000a0000 00000001 00000004 00000000 †................
00000000107CC6B0:   00000000 00000000 00100000 80010045 †...............E
00000000107CC6C0:   0063006f 006e0074 00720061 00630074 †.c.o.n.t.r.a.c.t
00000000107CC6D0:   0030002d 00490000 0000000a 00000038 †.0.-.I.........8
00000000107CC6E0:   38000000 04000a00 00000000 01000000 †8...............
00000000107CC6F0:   04000000 00000000 00000000 00001000 †................
00000000107CC700:   00800100 3f007300 76006300 69006400 †....?.s.v.c.i.d.
00000000107CC710:   30002d00 49000000 00000b00 00002424 †0.-.I.........$$
00000000107CC720:   00000010 00000000 00000001 00000010 †................
00000000107CC730:   00000000 00000000 00000000 00100000 †................
00000000107CC740:   80010047 0063006f 006e0076 00670072 †...G.c.o.n.v.g.r
00000000107CC750:   006f0075 00700030 002d0049 00000000 †.o.u.p.0.-.I....
00000000107CC760:   000c0000 007f7f00 00000800 13000000 †................
00000000107CC770:   00000100 00000800 00000000 00000000 †................
00000000107CC780:   00000000 10000080 01004100 73007900 †..........A.s.y.
00000000107CC790:   73007300 65007100 30002d00 49000000 †s.s.e.q.0.-.I...
00000000107CC7A0:   00000d00 00007f7f 00000008 00130000 †................
00000000107CC7B0:   00000001 00000008 00000000 00000000 †................
00000000107CC7C0:   00000000 00100000 80010047 0065006e †...........G.e.n
00000000107CC7D0:   00640064 006c0067 00730065 00710030 †.d.d.l.g.s.e.q.0
00000000107CC7E0:   002d0049 00000000 000e0000 007f7f00 †.-.I............
00000000107CC7F0:   00000800 13000000 00000100 00000800 †................
00000000107CC800:   00000000 00000000 00000000 10000080 †................
00000000107CC810:   01004b00 66006900 72007300 74006f00 †..K.f.i.r.s.t.o.
00000000107CC820:   6f007200 64006500 72003000 2d004900 †o.r.d.e.r.0.-.I.
00000000107CC830:   00000000 0f000000 7f7f0000 00080013 †................
00000000107CC840:   00000000 00010000 00080000 00000000 †................
00000000107CC850:   00000000 00000010 00008001 0049006c †.............I.l
00000000107CC860:   00610073 0074006f 006f0072 00640065 †.a.s.t.o.o.r.d.e
00000000107CC870:   00720030 002d0049 00000000 00100000 †.r.0.-.I........
00000000107CC880:   00383800 00000400 0a000000 00000100 †.88.............
00000000107CC890:   00000400 00000000 00000000 00000000 †................
00000000107CC8A0:   10000080 01004d00 6c006100 73007400 †......M.l.a.s.t.
00000000107CC8B0:   6f006f00 72006400 65007200 66007200 †o.o.r.d.e.r.f.r.
00000000107CC8C0:   30002d00 49000000 00001100 00003d3d †0.-.I.........==
00000000107CC8D0:   00000008 00170300 00000001 00000008 †................
00000000107CC8E0:   00000000 00000000 00000000 00100000 †................
00000000107CC8F0:   80010045 0064006c 00670074 0069006d †...E.d.l.g.t.i.m
00000000107CC900:   00650072 0030002d 00490000 00000012 †.e.r.0.-.I......
00000000107CC910:   0000003d 3d000000 08001703 00000000 †...==...........
00000000107CC920:   01000000 08000000 00000000 00000000 †................
00000000107CC930:   00001000 00800100 47006400 6c006700 †........G.d.l.g.
00000000107CC940:   6f007000 65006e00 65006400 30002d00 †o.p.e.n.e.d.0.-.
00000000107CC950:   49000000 00001300 00003838 00000004 †I.........88....
00000000107CC960:   000a0000 00000001 00000004 00000000 †................
00000000107CC970:   00000000 00000000 00100000 80010043 †...............C
00000000107CC980:   00700072 0069006e 00630069 00640030 †.p.r.i.n.c.i.d.0
00000000107CC990:   002d0049 00000000 00140000 00a5a500 †.-.I.........¥¥.
00000000107CC9A0:   00003800 00000000 00000300 00003800 †..8...........8.
00000000107CC9B0:   00000000 00000000 00000000 10000080 †................
00000000107CC9C0:   01004700 6f007500 74007300 65007300 †..G.o.u.t.s.e.s.
00000000107CC9D0:   6b006500 79003000 2d004900 00000000 †k.e.y.0.-.I.....
00000000107CC9E0:   15000000 24240000 00100000 00000000 †....$$..........
00000000107CC9F0:   00010000 00100000 00000000 00000000 †................
00000000107CCA00:   00000010 00008001 004b006f 00750074 †.........K.o.u.t
00000000107CCA10:   00730065 0073006b 00650079 00690064 †.s.e.s.k.e.y.i.d
00000000107CCA20:   0030002d 00490000 00000016 00000038 †.0.-.I.........8
00000000107CCA30:   38000000 04000a00 00000000 01000000 †8...............
00000000107CCA40:   04000000 00000000 00000000 00001000 †................
00000000107CCA50:   00800100 49006600 61007200 70007200 †....I.f.a.r.p.r.
00000000107CCA60:   69006e00 63006900 64003000 2d004900 †i.n.c.i.d.0.-.I.
00000000107CCA70:   00000000 17000000 a5a50000 00380000 †........¥¥...8..
00000000107CCA80:   00000000 00030000 00380000 00000000 †.........8......
00000000107CCA90:   00000000 00000010 00008001 00450069 †.............E.i
00000000107CCAA0:   006e0073 00650073 006b0065 00790030 †.n.s.e.s.k.e.y.0
00000000107CCAB0:   002d0049 00000000 00180000 00242400 †.-.I.........$$.
00000000107CCAC0:   00001000 00000000 00000100 00001000 †................
00000000107CCAD0:   00000000 00000000 00000000 10000080 †................
00000000107CCAE0:   01004900 69006e00 73006500 73006b00 †..I.i.n.s.e.s.k.
00000000107CCAF0:   65007900 69006400 30002d00 49000000 †e.y.i.d.0.-.I...
00000000107CCB00:   00001900 0000e7e7 00000000 02000008 †......çç........
00000000107CCB10:   00010003 00000000 02000000 00000000 †................
00000000107CCB20:   00000000 00100000 80010041 00660061 †...........A.f.a
00000000107CCB30:   00720073 00760063 0030002d 00490000 †.r.s.v.c.0.-.I..
00000000107CCB40:   0000001a 000000e7 e7000000 00010000 †.......çç.......
00000000107CCB50:   08000100 02000000 00010000 00000000 †................
00000000107CCB60:   00000000 00001000 00800100 4b006600 †............K.f.
00000000107CCB70:   61007200 62007200 6b007200 69006e00 †a.r.b.r.k.r.i.n.
00000000107CCB80:   73007400 30002d00 49000000 00001b00 †s.t.0.-.I.......
00000000107CCB90:   00003030 00000001 00030000 00000001 †..00............
00000000107CCBA0:   00000001 00000000 00000000 00000000 †................
00000000107CCBB0:   00100000 80010045 00700072 0069006f †.......E.p.r.i.o
00000000107CCBC0:   00720069 00740079 000000ad ad000000 †.r.i.t.y...­­...
00000000107CCBD0:   0a000000 00000000 02000000 0a000000 †................
00000000107CCBE0:   00000000 00000000 00001000 00800100 †................
00000000107CCBF0:   47006200 61006300 6b007500 70006c00 †G.b.a.c.k.u.p.l.
00000000107CCC00:   73006e00 30002d00 4c000000 00001600 †s.n.0.-.L.......
00000000107CCC10:   0000adad 0000000a 00000000 00000002 †..­­............
00000000107CCC20:   0000000a 00000000 00000000 00000000 †................
00000000107CCC30:   00100000 8001004b 00640069 00660066 †.......K.d.i.f.f
00000000107CCC40:   00620061 00730065 006c0073 006e0030 †.b.a.s.e.l.s.n.0
00000000107CCC50:   002d004c 00000000 00170000 00242400 †.-.L.........$$.
00000000107CCC60:   00001000 00000000 00000100 00001000 †................
00000000107CCC70:   00000000 00000000 00000000 10000080 †................
00000000107CCC80:   01004d00 64006900 66006600 62006100 †..M.d.i.f.f.b.a.
00000000107CCC90:   73006500 67007500 69006400 30002d00 †s.e.g.u.i.d.0.-.
00000000107CCCA0:   4c000000 00001800 00003d3d 00000008 †L.........==....
00000000107CCCB0:   00170300 00000001 00000008 00000000 †................
00000000107CCCC0:   00000000 00000000 00100000 8001004d †...............M
00000000107CCCD0:   00640069 00660066 00620061 00730065 †.d.i.f.f.b.a.s.e
00000000107CCCE0:   00740069 006d0065 0030002d 004c0000 †.t.i.m.e.0.-.L..
00000000107CCCF0:   00000019 000000ad ad000000 0a000000 †.......­­.......
00000000107CCD00:   00000000 02000000 0a000000 00000000 †................
00000000107CCD10:   00000000 00001000 00800100 51006400 †............Q.d.
00000000107CCD20:   69006600 66006200 61007300 65007300 †i.f.f.b.a.s.e.s.
00000000107CCD30:   65006300 6c007300 6e003000 2d004c00 †e.c.l.s.n.0.-.L.
00000000107CCD40:   00000000 1a000000 adad0000 000a0000 †........­­......
00000000107CCD50:   00000000 00020000 000a0000 00000000 †................
00000000107CCD60:   00000000 00000010 00008001 004d0072 †.............M.r
00000000107CCD70:   00650064 006f0073 00740061 00720074 †.e.d.o.s.t.a.r.t
00000000107CCD80:   006c0073 006e0030 002d004c 00000000 †.l.s.n.0.-.L....
00000000107CCD90:   001b0000 00adad00 00000a00 00000000 †.....­­.........
00000000107CCDA0:   00000200 00000a00 00000000 00000000 †................
00000000107CCDB0:   00000000 10000080 01004f00 72006500 †..........O.r.e.
00000000107CCDC0:   64006f00 74006100 72006700 65007400 †d.o.t.a.r.g.e.t.
00000000107CCDD0:   6c007300 6e003000 2d004c00 00000000 †l.s.n.0.-.L.....
00000000107CCDE0:   1c000000 24240000 00100000 00000000 †....$$..........
00000000107CCDF0:   00010000 00100000 00000000 00000000 †................
00000000107CCE00:   00000010 00008001 00450066 006f0072 †.........E.f.o.r
00000000107CCE10:   006b0067 00750069 00640030 002d004c †.k.g.u.i.d.0.-.L
00000000107CCE20:   00000000 001d0000 00adad00 00000a00 †.........­­.....
00000000107CCE30:   00000000 00000200 00000a00 00000000 †................
00000000107CCE40:   00000000 00000000 10000080 01004300 †..............C.
00000000107CCE50:   66006f00 72006b00 6c007300 6e003000 †f.o.r.k.l.s.n.0.
00000000107CCE60:   2d004c00 00000000 1e000000 7f7f0000 †-.L.............
00000000107CCE70:   00080013 00000000 00010000 00080000 †................
00000000107CCE80:   00000000 00000000 00000010 00008001 †................
00000000107CCE90:   00410066 006f0072 006b0076 00630030 †.A.f.o.r.k.v.c.0
00000000107CCEA0:   002d004c 00000000 001f0000 00242400 †.-.L.........$$.
00000000107CCEB0:   00001000 00000000 00000100 00001000 †................
00000000107CCEC0:   00000000 00000000 00000000 10000080 †................
00000000107CCED0:   01005700 72006500 64006f00 73007400 †..W.r.e.d.o.s.t.
00000000107CCEE0:   61007200 74006600 6f007200 6b006700 †a.r.t.f.o.r.k.g.
00000000107CCEF0:   75006900 64003000 2d004e00 00000000 †u.i.d.0.-.N.....
00000000107CCF00:   01000000 30300000 00010003 00000000 †....00..........
00000000107CCF10:   00010000 00010000 00000000 00000000 †................
00000000107CCF20:   00000010 00008001 003f0063 006c0061 †.........?.c.l.a
00000000107CCF30:   00730073 0030002d 004e0000 00000002 †.s.s.0.-.N......
00000000107CCF40:   00000038 38000000 04000a00 00000000 †...88...........
00000000107CCF50:   01000000 04000000 00000000 00000000 †................
00000000107CCF60:   00001000 00800100 39006900 64003000 †........9.i.d.0.
00000000107CCF70:   2d004e00 00000000 03000000 38380000 †-.N.........88..
00000000107CCF80:   0004000a 00000000 00010000 00040000 †................
00000000107CCF90:   00000000 00000000 00000010 00008001 †................
00000000107CCFA0:   003f0073 00750062 00690064 0030002d †.?.s.u.b.i.d.0.-
00000000107CCFB0:   004e0000 00000004 00000024 24000000 †.N.........$$...
00000000107CCFC0:   10000000 00000000 01000000 10000000 †................
00000000107CCFD0:   00000000 00000000 00001000 00800100 †................
00000000107CCFE0:   3d006700 75006900 64003000 2d004e00 †=.g.u.i.d.0.-.N.
00000000107CCFF0:   00000000 05000000 38380000 0004000a †........88......
00000000107CD000:   00000000 00010000 00040000 00000000 †................
00000000107CD010:   00000000 00000010 00008001 00410073 †.............A.s
00000000107CD020:   00740061 00740075 00730030 002d005a †.t.a.t.u.s.0.-.Z
00000000107CD030:   00000000 00010000 00383800 00000400 †.........88.....
00000000107CD040:   0a000000 00000100 00000400 00000000 †................
00000000107CD050:   00000000 00000000 10000080 01003b00 †..............;.
00000000107CD060:   71006900 64003000 2d005a00 00000000 †q.i.d.0.-.Z.....
00000000107CD070:   02000000 38380000 0004000a 00000000 †....88..........
00000000107CD080:   00010000 00040000 00000000 00000000 †................
00000000107CD090:   00000010 00008001 003d0068 00610073 †.........=.h.a.s
00000000107CD0A0:   00680030 002d005a 00000000 00030000 †.h.0.-.Z........
00000000107CD0B0:   00383800 00000400 0a000000 00000100 †.88.............
00000000107CD0C0:   00000400 00000000 00000000 00000000 †................
00000000107CD0D0:   10000080 01003b00 6e006900 64003000 †......;.n.i.d.0.
00000000107CD0E0:   2d005a00 00000000 04000000 e7e70000 †-.Z.........çç..
00000000107CD0F0:   00401f00 00080001 00030000 00401f00 †.@...........@..
00000000107CD100:   00000000 00000000 00000010 00008001 †................
00000000107CD110:   003d006e 0061006d 00650030 002d005b †.=.n.a.m.e.0.-.[
00000000107CD120:   00000000 00010000 00383800 00000400 †.........88.....
00000000107CD130:   0a000000 00000100 00000400 00000000 †................
00000000107CD140:   00000000 00000000 10000080 01003900 †..............9.
00000000107CD150:   69006400 30002d00 5b000000 00000200 †i.d.0.-.[.......
00000000107CD160:   00003838 00000004 000a0000 00000001 †..88............
00000000107CD170:   00000004 00000000 00000000 00000000 †................
00000000107CD180:   00100000 8001003f 00780073 00640069 †.......?.x.s.d.i
00000000107CD190:   00640030 002d005b 00000000 00030000 †.d.0.-.[........
00000000107CD1A0:   00383800 00000400 0a000000 00000100 †.88.............
00000000107CD1B0:   00000400 00000000 00000000 00000000 †................
00000000107CD1C0:   10000080 01004100 75007200 69006f00 †......A.u.r.i.o.
00000000107CD1D0:   72006400 30002d00 5b000000 00000400 †r.d.0.-.[.......
00000000107CD1E0:   00003030 00000001 00030000 00000001 †..00............
00000000107CD1F0:   00000001 00000000 00000000 00000000 †................
00000000107CD200:   00100000 8001003d 00710075 0061006c †.......=.q.u.a.l
00000000107CD210:   0030002d 005b0000 00000005 00000038 †.0.-.[.........8
00000000107CD220:   38000000 04000a00 00000000 01000000 †8...............
00000000107CD230:   04000000 00000000 00000000 00001000 †................
00000000107CD240:   00800100 41006e00 61006d00 65006900 †....A.n.a.m.e.i.
00000000107CD250:   64003000 2d005b00 00000000 06000000 †d.0.-.[.........
00000000107CD260:   afaf0000 00010000 00080001 00030000 †¯¯..............
00000000107CD270:   00010000 00000000 00000000 00000010 †................
00000000107CD280:   00008001 00450073 0079006d 00730070 †.....E.s.y.m.s.p
00000000107CD290:   00610063 00650030 002d005b 00000000 †.a.c.e.0.-.[....
00000000107CD2A0:   00070000 00383800 00000400 0a000000 †.....88.........
00000000107CD2B0:   00000100 00000400 00000000 00000000 †................
00000000107CD2C0:   00000000 10000080 01004300 6e006d00 †..........C.n.m.
00000000107CD2D0:   73006300 6f007000 65003000 2d005b00 †s.c.o.p.e.0.-.[.
00000000107CD2E0:   00000000 08000000 afaf0000 00010000 †........¯¯......
00000000107CD2F0:   00080001 00030000 00010000 00000000 †................
00000000107CD300:   00000000 00000010 00008001 003d006b †.............=.k
00000000107CD310:   0069006e 00640030 002d005b 00000000 †.i.n.d.0.-.[....
00000000107CD320:   00090000 00afaf00 00000100 00000800 †. ...¯¯.........
00000000107CD330:   01000300 00000100 00000000 00000000 †................
00000000107CD340:   00000000 10000080 01003f00 64006500 †..........?.d.e.
00000000107CD350:   72006900 76003000 2d005b00 00000000 †r.i.v.0.-.[.....
00000000107CD360:   0a000000 38380000 0004000a 00000000 †....88..........
00000000107CD370:   00010000 00040000 00000000 00000000 †................
00000000107CD380:   00000010 00008001 00410073 00740061 †.........A.s.t.a
00000000107CD390:   00740075 00730030 002d005b 00000000 †.t.u.s.0.-.[....
00000000107CD3A0:   000b0000 00afaf00 00000100 00000800 †.....¯¯.........
00000000107CD3B0:   01000300 00000100 00000000 00000000 †................
00000000107CD3C0:   00000000 10000080 01003d00 65006e00 †..........=.e.n.
00000000107CD3D0:   75006d00 30002d00 5b000000 00000c00 †u.m.0.-.[.......
00000000107CD3E0:   0000e7e7 00000040 1f000008 00010002 †..çç...@........
00000000107CD3F0:   00000040 1f000000 00000000 00000000 †...@............
00000000107CD400:   00100000 80010041 00640065 00660076 †.......A.d.e.f.v
00000000107CD410:   0061006c 0030002d 005c0000 00000001 †.a.l.0.-.\......
00000000107CD420:   00000038 38000000 04000a00 00000000 †...88...........
00000000107CD430:   01000000 04000000 00000000 00000000 †................
00000000107CD440:   00001000 00800100 41006300 6f006d00 †........A.c.o.m.
00000000107CD450:   70006900 64003000 2d005c00 00000000 †p.i.d.0.-.\.....
00000000107CD460:   02000000 38380000 0004000a 00000000 †....88..........
00000000107CD470:   00010000 00040000 00000000 00000000 †................
00000000107CD480:   00000010 00008001 003b006f 00720064 †.........;.o.r.d
00000000107CD490:   0030002d 005c0000 00000003 000000af †.0.-.\.........¯
00000000107CD4A0:   af000000 02000000 08000100 03000000 †¯...............
00000000107CD4B0:   02000000 00000000 00000000 00001000 †................
00000000107CD4C0:   00800100 3d006b00 69006e00 64003000 †....=.k.i.n.d.0.
00000000107CD4D0:   2d005c00 00000000 04000000 34340000 †-.\.........44..
00000000107CD4E0:   00020005 00000000 00010000 00020000 †................
00000000107CD4F0:   00000000 00000000 00000010 00008001 †................
00000000107CD500:   00410073 00740061 00740075 00730030 †.A.s.t.a.t.u.s.0
00000000107CD510:   002d005c 00000000 00050000 00e7e700 †.-.\.........çç.
00000000107CD520:   0000401f 00000800 01000200 0000401f †..@...........@.
00000000107CD530:   00000000 00000000 00000000 10000080 †................
00000000107CD540:   01003d00 64006600 6c007400 30002d00 †..=.d.f.l.t.0.-.
00000000107CD550:   5d000000 00000100 00003838 00000004 †].........88....
00000000107CD560:   000a0000 00000001 00000004 00000000 †................
00000000107CD570:   00000000 00000000 00100000 80010047 †...............G
00000000107CD580:   0070006c 00610063 0069006e 00670069 †.p.l.a.c.i.n.g.i
00000000107CD590:   00640030 002d005d 00000000 00020000 †.d.0.-.]........
00000000107CD5A0:   00383800 00000400 0a000000 00000100 †.88.............
00000000107CD5B0:   00000400 00000000 00000000 00000000 †................
00000000107CD5C0:   10000080 01004300 6f007200 64006900 †......C.o.r.d.i.
00000000107CD5D0:   6e006100 6c003000 2d005d00 00000000 †n.a.l.0.-.].....
00000000107CD5E0:   03000000 38380000 0004000a 00000000 †....88..........
00000000107CD5F0:   00010000 00040000 00000000 00000000 †................
00000000107CD600:   00000010 00008001 00450070 006c0061 †.........E.p.l.a
00000000107CD610:   00630065 00640069 00640030 002d005d †.c.e.d.i.d.0.-.]
00000000107CD620:   00000000 00040000 00383800 00000400 †.........88.....
00000000107CD630:   0a000000 00000100 00000400 00000000 †................
00000000107CD640:   00000000 00000000 10000080 01004100 †..............A.
00000000107CD650:   73007400 61007400 75007300 30002d00 †s.t.a.t.u.s.0.-.
00000000107CD660:   5d000000 00000500 00003838 00000004 †].........88....
00000000107CD670:   000a0000 00000001 00000004 00000000 †................
00000000107CD680:   00000000 00000000 00100000 80010045 †...............E
00000000107CD690:   006d0069 006e006f 00630063 00750072 †.m.i.n.o.c.c.u.r
00000000107CD6A0:   0030002d 005d0000 00000006 00000038 †.0.-.].........8
00000000107CD6B0:   38000000 04000a00 00000000 01000000 †8...............
00000000107CD6C0:   04000000 00000000 00000000 00001000 †................
00000000107CD6D0:   00800100 45006d00 61007800 6f006300 †....E.m.a.x.o.c.
00000000107CD6E0:   63007500 72003000 2d005d00 00000000 †c.u.r.0.-.].....
00000000107CD6F0:   07000000 e7e70000 00401f00 00080001 †....çç...@......
00000000107CD700:   00020000 00401f00 00000000 00000000 †.....@..........
00000000107CD710:   00000010 00008001 00410064 00650066 †.........A.d.e.f
00000000107CD720:   00760061 006c0030 002d0061 00000000 †.v.a.l.0.-.a....
00000000107CD730:   00010000 00303000 00000100 03000000 †.....00.........
00000000107CD740:   00000100 00000100 00000000 00000000 †................
00000000107CD750:   00000000 10000080 01003f00 63006c00 †..........?.c.l.
00000000107CD760:   61007300 73003000 2d006100 00000000 †a.s.s.0.-.a.....
00000000107CD770:   02000000 38380000 0004000a 00000000 †....88..........
00000000107CD780:   00010000 00040000 00000000 00000000 †................
00000000107CD790:   00000010 00008001 00430069 0064006d †.........C.i.d.m
00000000107CD7A0:   0061006a 006f0072 0030002d 00610000 †.a.j.o.r.0.-.a..
00000000107CD7B0:   00000003 00000038 38000000 04000a00 †.......88.......
00000000107CD7C0:   00000000 01000000 04000000 00000000 †................
00000000107CD7D0:   00000000 00001000 00800100 3f007300 †............?.s.
00000000107CD7E0:   75006200 69006400 30002d00 61000000 †u.b.i.d.0.-.a...
00000000107CD7F0:   00000400 0000e700 01000000 01000008 †......ç.........
00000000107CD800:   00010003 00000000 01000000 00000000 †................
00000000107CD810:   00000000 00100000 8001003d 006e0061 †...........=.n.a
00000000107CD820:   006d0065 0030002d 00610000 00000005 †.m.e.0.-.a......
00000000107CD830:   00000038 38000000 04000a00 00000000 †...88...........
00000000107CD840:   01000000 04000000 00000000 00000000 †................
00000000107CD850:   00001000 00800100 41007300 74006100 †........A.s.t.a.
00000000107CD860:   74007500 73003000 2d006100 00000000 †t.u.s.0.-.a.....
00000000107CD870:   06000000 38380000 0004000a 00000000 †....88..........
00000000107CD880:   00010000 00040000 00000000 00000000 †................
00000000107CD890:   00000010 00008001 00430069 006e0074 †.........C.i.n.t
00000000107CD8A0:   00700072 006f0070 0030002d 00480000 †.p.r.o.p.0.-.H..
00000000107CD8B0:   00000001 00000024 24000000 10000000 †.......$$.......
00000000107CD8C0:   00000000 01000000 10000000 00000000 †................
00000000107CD8D0:   00000000 00001000 00800100 41006800 †............A.h.
00000000107CD8E0:   61006e00 64006c00 65003000 2d004800 †a.n.d.l.e.0.-.H.
00000000107CD8F0:   00000000 02000000 24240000 00100000 †........$$......
00000000107CD900:   00000000 00010000 00100000 00000000 †................
00000000107CD910:   00000000 00000010 00008001 00410064 †.............A.d
00000000107CD920:   00690061 00670069 00640030 002d0048 †.i.a.g.i.d.0.-.H
00000000107CD930:   00000000 00030000 00303000 00000100 †.........00.....
00000000107CD940:   03000000 00000100 00000100 00000000 †................
00000000107CD950:   00000000 00000000 10000080 01004700 †..............G.
00000000107CD960:   69006e00 69007400 69006100 74006f00 †i.n.i.t.i.a.t.o.
00000000107CD970:   72003000 2d004800 00000000 04000000 †r.0.-.H.........
00000000107CD980:   7f7f0000 00080013 00000000 00010000 †................
00000000107CD990:   00080000 00000000 00000000 00000010 †................
00000000107CD9A0:   00008001 00430073 0065006e 00640073 †.....C.s.e.n.d.s
00000000107CD9B0:   00650071 0030002d 00480000 00000005 †.e.q.0.-.H......
00000000107CD9C0:   000000ad ad000000 06000000 00000000 †...­­...........
00000000107CD9D0:   03000000 06000000 00000000 00000000 †................
00000000107CD9E0:   00001000 00800100 45007300 65006e00 †........E.s.e.n.
00000000107CD9F0:   64007800 61006300 74003000 2d004900 †d.x.a.c.t.0.-.I.
00000000107CDA00:   00000000 01000000 24240000 00100000 †........$$......
00000000107CDA10:   00000000 00010000 00100000 00000000 †................
00000000107CDA20:   00000000 00000010 00008001 00410064 †.............A.d
00000000107CDA30:   00690061 00670069 00640030 002d0049 †.i.a.g.i.d.0.-.I
00000000107CDA40:   00000000 00020000 00303000 00000100 †.........00.....
00000000107CDA50:   03000000 00000100 00000100 00000000 †................
00000000107CDA60:   00000000 00000000 10000080 01004700 †..............G.
00000000107CDA70:   69006e00 69007400 69006100 74006f00 †i.n.i.t.i.a.t.o.
00000000107CDA80:   72003000 2d004900 00000000 03000000 †r.0.-.I.........
00000000107CDA90:   24240000 00100000 00000000 00010000 †$$..............
00000000107CDAA0:   00100000 00000000 00000000 00000010 †................
00000000107CDAB0:   00008001 00410068 0061006e 0064006c †.....A.h.a.n.d.l
00000000107CDAC0:   00650030 002d0049 00000000 00040000 †.e.0.-.I........
00000000107CDAD0:   007f7f00 00000800 13000000 00000100 †................
00000000107CDAE0:   00000800 00000000 00000000 00000000 †................
00000000107CDAF0:   10000080 01004100 72006300 76007300 †......A.r.c.v.s.
00000000107CDB00:   65007100 30002d00 49000000 00000500 †e.q.0.-.I.......
00000000107CDB10:   00003838 00000004 000a0000 00000001 †..88............
00000000107CDB20:   00000004 00000000 00000000 00000000 †................
00000000107CDB30:   00100000 80010043 00720063 00760066 †.......C.r.c.v.f
00000000107CDB40:   00720061 00670030 002d0049 00000000 †.r.a.g.0.-.I....
00000000107CDB50:   00060000 00383800 00000400 0a000000 †.....88.........
00000000107CDB60:   00000100 00000400 00000000 00000000 †................
00000000107CDB70:   00000000 10000080 01004100 73007400 †..........A.s.t.
00000000107CDB80:   61007400 75007300 30002d00 49000000 †a.t.u.s.0.-.I...
00000000107CDB90:   00000700 0000afaf 00000002 00000008 †......¯¯........
00000000107CDBA0:   10000003 00000002 00000000 00000000 †................
00000000107CDBB0:   00000000 00100000 8001003f 00730074 †...........?.s.t
00000000107CDBC0:   00610074 00650030 002d0049 00000000 †.a.t.e.0.-.I....
00000000107CDBD0:   00080000 003d3d00 00000800 17030000 †.....==.........
00000000107CDBE0:   00000100 00000800 00000000 00000000 †................
00000000107CDBF0:   00000000 10000080 01004500 6c006900 †..........E.l.i.
00000000107CDC00:   66006500 74006900 6d006500 30002d00 †f.e.t.i.m.e.0.-.
00000000107CDC10:   49000000 00000900 00003838 00000004 †I..... ...88....
00000000107CDC20:   000a0000 00000001 00000004 00000000 †................
00000000107CDC30:   00000000 00000000 00100000 80010045 †...............E
00000000107CDC40:   0063006f 006e0074 00720061 00630074 †.c.o.n.t.r.a.c.t
00000000107CDC50:   0030002d 00490000 0000000a 00000038 †.0.-.I.........8
00000000107CDC60:   38000000 04000a00 00000000 01000000 †8...............
00000000107CDC70:   04000000 00000000 00000000 00001000 †................
00000000107CDC80:   00800100 3f007300 76006300 69006400 †....?.s.v.c.i.d.
00000000107CDC90:   30002d00 49000000 00000b00 00002424 †0.-.I.........$$
00000000107CDCA0:   00000010 00000000 00000001 00000010 †................
00000000107CDCB0:   00000000 00000000 00000000 00100000 †................
00000000107CDCC0:   80010047 0063006f 006e0076 00670072 †...G.c.o.n.v.g.r
00000000107CDCD0:   006f0075 00700030 002d0049 00000000 †.o.u.p.0.-.I....
00000000107CDCE0:   000c0000 007f7f00 00000800 13000000 †................
00000000107CDCF0:   00000100 00000800 00000000 00000000 †................
00000000107CDD00:   00000000 10000080 01004100 73007900 †..........A.s.y.
00000000107CDD10:   73007300 65007100 30002d00 49000000 †s.s.e.q.0.-.I...
00000000107CDD20:   00000d00 00007f7f 00000008 00130000 †................
00000000107CDD30:   00000001 00000008 00000000 00000000 †................
00000000107CDD40:   00000000 00100000 80010047 0065006e †...........G.e.n
00000000107CDD50:   00640064 006c0067 00730065 00710030 †.d.d.l.g.s.e.q.0
00000000107CDD60:   002d0049 00000000 000e0000 007f7f00 †.-.I............
00000000107CDD70:   00000800 13000000 00000100 00000800 †................
00000000107CDD80:   00000000 00000000 00000000 10000080 †................
00000000107CDD90:   01004b00 66006900 72007300 74006f00 †..K.f.i.r.s.t.o.
00000000107CDDA0:   6f007200 64006500 72003000 2d004900 †o.r.d.e.r.0.-.I.
00000000107CDDB0:   00000000 0f000000 7f7f0000 00080013 †................
00000000107CDDC0:   00000000 00010000 00080000 00000000 †................
00000000107CDDD0:   00000000 00000010 00008001 0049006c †.............I.l
00000000107CDDE0:   00610073 0074006f 006f0072 00640065 †.a.s.t.o.o.r.d.e
00000000107CDDF0:   00720030 002d0049 00000000 00100000 †.r.0.-.I........
00000000107CDE00:   00383800 00000400 0a000000 00000100 †.88.............
00000000107CDE10:   00000400 00000000 00000000 00000000 †................
00000000107CDE20:   10000080 01004d00 6c006100 73007400 †......M.l.a.s.t.
00000000107CDE30:   6f006f00 72006400 65007200 66007200 †o.o.r.d.e.r.f.r.
00000000107CDE40:   30002d00 49000000 00001100 00003d3d †0.-.I.........==
00000000107CDE50:   00000008 00170300 00000001 00000008 †................
00000000107CDE60:   00000000 00000000 00000000 00100000 †................
00000000107CDE70:   80010045 0064006c 00670074 0069006d †...E.d.l.g.t.i.m
00000000107CDE80:   00650072 0030002d 00490000 00000012 †.e.r.0.-.I......
00000000107CDE90:   0000003d 3d000000 08001703 00000000 †...==...........
00000000107CDEA0:   01000000 08000000 00000000 00000000 †................
00000000107CDEB0:   00001000 00800100 47006400 6c006700 †........G.d.l.g.
00000000107CDEC0:   6f007000 65006e00 65006400 30002d00 †o.p.e.n.e.d.0.-.
00000000107CDED0:   49000000 00001300 00003838 00000004 †I.........88....
00000000107CDEE0:   000a0000 00000001 00000004 00000000 †................
00000000107CDEF0:   00000000 00000000 00100000 80010043 †...............C
00000000107CDF00:   00700072 0069006e 00630069 00640030 †.p.r.i.n.c.i.d.0
00000000107CDF10:   002d0049 00000000 00140000 00a5a500 †.-.I.........¥¥.
00000000107CDF20:   00003800 00000000 00000300 00003800 †..8...........8.
00000000107CDF30:   00000000 00000000 00000000 10000080 †................
00000000107CDF40:   01004700 6f007500 74007300 65007300 †..G.o.u.t.s.e.s.
00000000107CDF50:   6b006500 79003000 2d004900 00000000 †k.e.y.0.-.I.....
00000000107CDF60:   15000000 24240000 00100000 00000000 †....$$..........
00000000107CDF70:   00010000 00100000 00000000 00000000 †................
00000000107CDF80:   00000010 00008001 004b006f 00750074 †.........K.o.u.t
00000000107CDF90:   00730065 0073006b 00650079 00690064 †.s.e.s.k.e.y.i.d
00000000107CDFA0:   00000006 bf057c05 3705840b 390bf80a †....¿.|.7.?.9.ø.
00000000107CDFB0:   af0a6a0a 210ad609 8f094c09 0509c008 †¯.j.!.Ö . L . À.
00000000107CDFC0:   73082a08 df079807 57071007 d1068c06 †s.*.ß...W...Ñ.?.
00000000107CDFD0:   47060806 c7058405 43050205 bb047a04 †G...Ç.?.C...».z.
00000000107CDFE0:   3504f203 ab036a03 2903e402 a3025a02 †5.ò.«.j.).ä.£.Z.
00000000107CDFF0:   3f011a01 0101dc00 c3009e00 85006000 †?.....Ü.Ã.?.?.`.

OFFSET TABLE:

Row - Offset                      
7 (0x7) - 319 (0x13f)              
6 (0x6) - 282 (0x11a)              
5 (0x5) - 257 (0x101)              
4 (0x4) - 220 (0xdc)              
3 (0x3) - 195 (0xc3)              
2 (0x2) - 158 (0x9e)              
1 (0x1) - 133 (0x85)              
0 (0x0) - 96 (0x60)                


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


reference:
http://www.sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Anatomy-of-a-record.aspx
http://www.sqlskills.com/BLOGS/PAUL/post/Inside-the-Storage-Engine-Anatomy-of-a-page.aspx
http://improve.dk/archive/2009/03/26/deciphering-a-sql-server-data-page.aspx
http://sqlsimplified.blogspot.com/2012/01/page-header_12.html




Comments

Leave a comment on the original post [jamessql.blogspot.com, opens in a new window]

Loading comments...