SQL Server %%physloc%%

http://sqlity.net/en/2451/physloc/

SELECT*,%%physloc%% ASphysloc

  FROMdbo.tst AST

ORDERBYphysloc;

SELECT*,sys.fn_PhysLocFormatter(%%physloc%%) ASPLF

  FROMdbo.tst AST

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;

Advertisements

---