SQL Server %%physloc%%
Posted: May 23, 2015 Filed under: Microsoft SQL Server | Tags: Microsoft SQL Server Leave a commenthttp://sqlity.net/en/2451/physloc/
SELECT
*,%%physloc%%
AS
physloc
FROM
dbo.tst
AS
T
ORDER
BY
physloc;
SELECT
*,sys.fn_PhysLocFormatter(%%physloc%%)
AS
PLF
FROM
dbo.tst
AS
T
ORDER
BY
PLF;
SELECT
*
FROM
dbo.tst
AS
T
CROSS
APPLY sys.fn_PhysLocCracker(%%physloc%%)
AS
FPLC
ORDER
BY
FPLC.file_id, FPLC.page_id, FPLC.slot_id;