Browse by Tags

Cumulative Update 7 available for SQL Server 2005 SP2 - get it now to test and apply (if needed)

Published 15 April 8 3:58 PM | SSQA.net

Here is another candidate of 7 within Cumulative Update service for SQL Server 2005 SP2. SQL Server Release Services team has announced (yesterday) that another instalment of Cumulative Update ( series here ) for SQL Server 2005 on Service Pack 2, it...

Filed under: sql server, microsoft, blogs, download, kba, service pack, cumulative update, downgrade, cu7, affected, releases

How to find whether that service pack file is a 32 bit or 64 bit?

Published 1 November 7 6:44 AM | SSQA.net

Whenever a service pack is released it will be available for 32-bit and 64-bit that also includes for SQL Express 2005 edition too, as it was for MSDE earlier. Since last year (I think) Microsoft Development team has adopted a standard in naming schema...

Filed under: sql server, msdn, microsoft, blogs, technet, download, kba, best practices, x64, testing, begin

Stored Procedures caught me with too many recomplies - way out to avoid it

Published 25 October 7 3:35 AM | SSQA.net

A common scenario in SQL Server environment that often application users complained about slow performance and same time you observe high CPU usage/spikes on the SQL Server instance, so better to follow the methods from HighCPU-whyitis blog and still...

Filed under: sql server, performance, indexes, blogs, kba, stored procedure, high cpu, recompile, too many

High CPU issues that are specific to SQL Server 2000 installations and few with SQL 2005 too!

Published 20 September 7 10:40 AM | SSQA.net

Here comes another Frequently Asked Question (FAQ) on the forums and Frequently Posted Blog (FPB) here about high cpu issues on the SQL Server 2000 instances. Looking at high cpu spiks and performace issues is a common problem in all SQL Server installations...

Filed under: sql server, performance, databases, blogs, blocking, query, kba, cpu, execution plan, backups, resources, high cpu, FAQ