Romanian SQL Server User Group

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 ...

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 is giving you 64K of live information that you can get usually using a trace, by ...