Archive for the ‘DBCC’ Category
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
1
2
3
4
Enjoy 🙂
Categories: Database Structure, DBCC, General
3604, allocation units, database page structure, DBCC ind, DBCC page, DBCC traceon, extend, GAM, IAM, partition, PFS, SGAM, SQL, YouTube