Cristian's Blog

If you need to see the physical structure of your database you can use DBCC PAGE as described here: Read Index Structure [quote] CREATE TABLE #DBCCIND( PageFID INT, PagePID INT, IAMFID INT, IAMPID INT, ObjectID INT, IndexID INT, PartitionNumber INT, PartitionID Read More...

A year and a half ago I wrote about the undocumented Dynamic Management View sys.dm_os_ring_buffers in SQL Server Professional . Shortly the ring buffers expose internal server state information about memory, exceptions, or schedulers. Each ring buffer Read More...