Thursday, September 30, 2010

Some new SQL Server Whitepapers

I receive permission to repost some white papers that I did this year for Microsoft, they are available below

  • Best Maintenance Tools for PTC Windchill on Microsoft SQL Server 2008 [PDF]
    • The majority of the content is generic and applies to almost any database running on SQL Server
  • Best Drive Configuration Practices for PTC Windchill on Microsoft SQL Server [PDF]
    • The majority of the content is generic and applies to almost any database running on SQL Server
  • Optimizing Fill Factor for SQL Server [PDF]
    • Going with the default fill factor and using GUIDs in indices is a dumb idea – it will often lead to 95% fragmentation of indices…
  • Using Management Data Warehouse for Performance Monitoring [PDF]
    • This is an ultra sweet component of SQL Server 2008. Imagine having performance monitor running always with all measures being recorded into a SQL Server database (including any custom ones you create). It exists and is part of SQL Server 2008. Learn about it and rule the bug reports!

1 comment: