David Fowler gets to the guts of a row as stored in SQL Server:
DBCC page will take in a database name or id, file id and page id and return a representation of the specified page depending on the print options that you choose.
We’ve got four different print options that we can choose,
0 – Return only the page header
1 – Return the page header and hex dump of each row
2 – Return the page header and full page hex dump
3 – Return the page header, hex dump of each row as well as the details on each column
Read the whole thing.