Top SQL Server Solutions from Microsoft Support
- SQL Server 2008 and SQL Server 2008 R2 clustering FAQ’s
- Use Pssdiag/Sqldiag Manager to collect troubleshooting data
- Use SQLNexus to identify the root cause of SQL Server performance issues
- Description of the Replay Markup Language (RML) Utilities for SQL Server
- Microsoft® SQL Server® 2012 Performance Dashboard Reports
- Troubleshooting Performance Problems in SQL Server 2008
- Search the SQL Server Performance blog for solutions to top performance issues
- SQL Server I/O Basics, Chapter 2
- Recommendations and Guidelines for 'max degree of parallelism' configuration option
- Working with tempdb in SQL Server 2005
Most Recent KBs for SQL Server 2008 R2
- You cannot run the SSIS package in 64-bit mode in SQL Server 2008 R2 or SQL Server 2008[…]
- FIX: Incorrect result when you run an MDX query that includes an Aggregate function that is used in a calculated member in SSAS 2008 R2 or SSAS 2012[…]
- FIX: Error when you run the sp_cursoropen stored procedure together with the scrollopt argument in SQL Server 2008 R2 or SQL Server 2012[…]
- FIX: Missing parameter panel of a drillthrough report when a top-level report contains hidden parameters or no parameters in SSRS 2008 R2 or SSRS 2012[…]
- FIX: The KeepTogether property may not work in SSRS 2008 R2 or SSRS 2012[…]
- FIX: Incorrect result when you run an MDX query that returns multiple calculated members in SSAS 2008, SSAS 2012 or SSAS 2008 R2[…]
- FIX: Globals!TotalPages variable returns incorrect number after you perform an in-place upgrade to SSRS 2008 R2 or SSRS 2012[…]
- FIX: Incorrect result when you run an MDX query against an SSAS 2008 R2 or SSAS 2012 database that has multiple data sources[…]
- Description of new features in Cumulative Update 4 for SQL Server 2012 SP1 and Cumulative Update 6 for SQL Server 2008 R2[…]
- FIX: PowerPivot database is not deleted from SSAS memory when PowerPivot database processing fails[…]
