Johan Åhlén

Johan Åhlén's blog about life, universe and everything.

Browse by Tags

All Tags » DBCC (RSS)
SQL Server Trace Flags - why and how to use them
Trace flags are very powerful settings that allow you to customize SQL Server behaviour. Most of the trace flags are undocumented in Books Online and there does not exist any official list of them. Some have been mentioned in Knowledge Base articles and...
Exploring SQL Server under the hood using undocumented DBCC commands
Have you ever wanted to see the details on how data is organised in a SQL Server database? Exactly how tables, indexes, blogs, etc are stored. How SQL Server can find a specific row in a table. This is possible through two undocumented DBCC commands:...