SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags T-SQL, sys.fn_PhysLocFormatter Rss

   Items 1 to 1 of 1   

How to use sys.fn_PhysLocFormatter undocumented function

It would be nice if we could use the DBCC PAGE command to see exactly what it is stored at the page level, however, in order to do this we need to find a way to correlate the results returned from a SELECT statement with the physical data location. Is that possible? The answer is: YES. All we need to do is use the sys.fn_physLocFormatter function. In this tip, I will cover how to use this undocumented function.  Read more...
By Additional Articles 2010/02/02 | Source: MSSQLTips.com | Category: sys.fn_physlocformatter
Rating:  Rate this |   Briefcase | 2,632 reads
   Items 1 to 1 of 1