• GilaMonster (10/10/2012)


    TagA and TagB are just the two bytes (first and second) of the record header, nothing fancier than that. You don't need to decode them, DBCC Page does it for you, it contains info lik "Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNS"

    The "00000000" is the offset, so byte 0 = offset 00000000, so the first byte of the dump, in this case, Byte 0 is 0x30. The record has a null bitmap and variable length columns (but I didn't need to decode the header for that, DBCC PAge did it for me "Record Attributes = NULL_BITMAP VARIABLE_COLUMNS"

    Argghhh bytes, bits, Hex, offsets 🙂

    Gail has already given you a good starter, the 0x30 is the hex value. The offset is the point in the file at which the record starts and then has a corresponding record length The slots are the records which you can see hold the column data. It's probably worth reading through this[/url] to get more of an understanding. Playing with a Hex editor on a test database should enlighten you more. Just don't run it on your Production systems or you won't be popular 🙂

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉