Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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,343 reads
   Items 1 to 1 of 1