Archives for: "April 2009"

Troubleshooting Performance Problems in SQL Server 2008

There is a new withe paper on SQL Server 2008 performance troubleshooting and covers the following in depth: CPU Bottlenecks Memory Bottlenecks I/O BottlenecksSlow-Running Queries Extended EventsData Collector and the MDWDownload from the Microsoft… more »

SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization

Ola Hallengren Ola, with his wonderful SQL Server 2005 and 2008 - Backup, Integrity Check and Index Optimization scripts - made some updates to his maintenance scripts: Support for Xml indexes Support for Spatial indexes Support for indexed views… more »

Whitepaper-Links collection page for SQL Server

Paul S. Randal and his wife Kimberly L. Tripp of SQLskills.com linked to whitepapers written/published by reputable sources, consolidated in a Whitepaper-Link Collection.Here it is: http://www.sqlskills.com/whitepapers.asp CU tosc more »

Cumulative update package 1 for SQL Server 2008 Service Pack 1

Is it true? YES, it is!Don't worry - be happy; Aaron Bertrand explains it in his post: http://sqlblog.com/blogs/aaron_bertrand/archive/2009/04/15/sql-server-2008-sp1-cumulative-update-1-is-available.aspx The Cumulative update package 1 for SQL Server… more »

Microsoft SQL Server 2008 Service Pack 1 now available!

It's out. The final release of SQL Server 2008 Service Pack 1 (Build 10.00.2531.00) is now available: http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=66ab3dbb-bf3e-4f46-9559-ccc6a4f9dc19Here the KB-Article of SP1: List of the… more »

SQL Server 2005/2008 Express free Profiler Tool

In one of my older post, I tell you about a realy good free profiler express edition tool for SQL Server 2005 ..A lot of features / tools are included with the SQL Sever 2005 Express Edition (GUI, Reporting Services etc.), but not all of them like the… more »