Category Archives: DBCC

Physical PageId Query

I was playing about this weekend and trying to use the DBCC PAGE command and stumbled across a function which was certainly new to me which could tell me on which page my data is stored.

use AdventureWorks2008R2
go
select
	sys.fn_PhysLocFormatter (%%physloc%%) as PhysicalRID, 
	BusinessEntityID,
	FirstName,
	ISNULL(MiddleName,'') as MiddleName,
	LastName
from Person.Person
order by LastName, FirstName, MiddleName
go

Continue reading