A Handy function

If you like learning about internals use the undocumented function to get the FileID:PageID of your table rows and use that in DBCC PAGE.

SELECT sys.fn_PhysLocFormatter (%%physloc%%)
FROM Person.EmailAddress;



Now set your trace flag on and read the contents of DBCC PAGE to satisfy your curiosity.


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s