Sometimes it is helpful to know on which page exactly SQL Server has stored a particular row. You can use the undocumented %%physloc%% virtual column, together with its supporting functions sys.fn_PhysLocFormatter and sys.fn_PhysLocCracker, to find out.
The database boot page contains database settings and configuration values. Read on to discover where to find this page and how to interpret its content.[more…]