Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Analysis Services (2000)
 SQL Server Storage Engine.

Author  Topic 

Jude_Aj
Starting Member

22 Posts

Posted - 2009-02-26 : 10:13:20
Hi,
I have been studying about the SQL server 2000 storage engine.
I was traversing the record of a tables(syscolumns).
I did a dbcc page. One of the records was as follows :-

30002e00 59ed607f 38003800 04000a00 0...Y.`.8.8.....
01000400 00000000 00000000 00000000 ................
00000100 ffff0000 00002000 2000[1500] .......... . ...
00000a01 00410065 006d0070 00690064 .....A.e.m.p.i.d
00b85921

notice that i have marked 1500 in "[ ]"

heres the same rec viewed in hex editor

30002E00 59ED607F 38003800 04000A00
01000400 00000000 00000000 00000000
00000100 FFFF0000 00002000 2000[1502]
00000A01 00410065 006D0070 00690064
00B85921

here if u notice the values 1500 in dbcc page dump is 1502 in hex editor.
Can anybody help me understand this?
Thanks...

Jude_Aj
Starting Member

22 Posts

Posted - 2009-03-02 : 02:31:04
This not only instance where there was a mismatch of a particular byte
in a record viewed in hex edit, from that viewed in dbcc page command(hex dump). Majority of the record viewed in hex editor are identical to that viewed using dbcc page command . Its just that there a few exceptions and i fail to understand why?
Go to Top of Page
   

- Advertisement -