Christoph Muthmann

A new version of Glenn Berrys queries is available!

Good news from Glenn Berry! He has finished his update on his set of Diagnostic Information Queries for SQL Server 2012.

There is a new set auf diagnostic queries by Glenn Berry available:
You will find them here!

The Microsoft SQL Server 2008 R2 System Views Map shows the key system views included in Microsoft SQL Server 2008 and SQL Server 2008 R2, and the relationships between them. The map is similar to the Microsoft SQL Server 2008 version and includes updates which are also applicable for the Microsoft SQL Server 2008.

You can download it from here!

Hallo Leute,
dieser Blog Eintrag von Paul S. Randal (er hat u. a. DBCC CHECKDB entwickelt) beschreibt recht anschaulich, dass man sich von den Vorschlägen des Optimizers nicht verrückt machen lassen sollte und selber mit Intelligenz ans Werk gehen muss, wenn man nach fehlenden Indizes fahndet. In der Version 11 (Achtung: SQL Server 2008 R2 ist Version 10.5) wird dies wohl gefixed:

http://www.sqlskills.com/BLOGS/PAUL/post/Missing-index-DMVs-bug-that-could-cost-your-sanity.aspx