Posts Tagged ‘SGAM’

Database Page Basics

December 27, 2013 Leave a comment

Hi all,

i was looking for a some basics to find out to which Table a particular page belongs to ..

Found below you tube Channel which covered everything i was looking for

check out the link and subscribe to the same ..   SQLpassion by  Klaus Aschenbrenner 

 you will cover below basics if you try out the example yourself ,

1>basic Database  PAGE Structure  and how to use DBCC IND , DBCC PAGE  and DBCC TRACEON(3604)

2> how the table partition and allocation units are related each other

3> what are different types of Allocation units  i.e in row ,LOB and row over-flow data

   Please try the example as you go through the the links 





Enjoy 🙂

corrupt allocation pages

July 9, 2013 Leave a comment

Hi There ,

                its heck of a pain to restore ,recover or do page level restore allocation pages and you have no other option other then doing a clean restore of your database ..

              some people can do a HEX editing on the file ,but that’s not recommenced

             for more info Check out DAVIS site .. and his 30 day series on Disaster and recovery 

          Enjoy 🙂