Archives for: "April 2009"
Troubleshooting Performance Problems in SQL Server 2008
Apr 21st
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
Apr 20th
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
Apr 16th
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
Apr 16th
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!
Apr 8th
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
Apr 3rd
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 »