Browse by Tags

Install cumulative update package 7 on a SQL Server Cluster?

Published 22 May 8 3:3 AM | SSQA.net

IN continuation to the post Rollback_of_CumulativeUpdate-hotfix-ServicePack I was asked about any procedure or steps on installing Cumulative update package 7 for SQL Server 2005 Service Pack 2 on Active node SQL 2005 cluster. The simple answer is all...

Filed under: sql server, best practices, hotfix, clustering, uninstall, cumulative update, css

End of Mainstream support for SQL Server 2000 & 2005 (SP1) today, then how about SP2?

Published 8 April 8 2:2 AM | SSQA.net

The subject say it all, as of today the mainstream support for SQL Server 2000 (SP4) and SQL Server 2005 (SP1) will be ended. That means for SQL Server 2005 service pack 1 there will not be any support and that can be obtained with a Custom Support agreement...

Filed under: sql server, sp2, support, lifecycle, 2000, 2005, service pack, css, case, mainstream, extended

Cumulative update package 6 for SQL Server 2005 Service Pack 2 - available now

Published 20 February 8 2:39 AM | SSQA.net

Another set of Cumulative update package ready to download for SQL Server 2005 Service Pack 2, again only by the way of contacting the CSS. From our CumulativeUpdate blog series here is another one to add up as well and this CU6 package is only intended...

Filed under: sql server, download, support, service pack2, sp_configure, costs, cumulative update, css, service pack3

How to use TSQL to find the size of total and free physical memory within the SQL Server?

Published 24 January 8 4:28 PM | SSQA.net

Recently I have to search for the information on the total size of free physical memory on the SQL Server which is causing lots of performance issues, when reported to CSS they have supplied the following TSQL to get more information in this regard: With...

Filed under: sql server, performance, memory, microsoft, dump, physical, tsql, select, css, size

SQL Server 2005 Service Pack 2 Cumulative Update 5 instalment available for download with a request to CSS!

Published 27 December 7 2:2 AM | SSQA.net

From the series of the SQL Server 2005 Service Pack2 Cumulative Update packages blogs and for instance we blogged about SQL2005SP2CU5 earlier, it is available to download now and before that there is a catch to obtain this package. It is not that easy...

Filed under: sql server, package, msdn, blogs, support, service pack2, testing, online, cumulative update, pss, css, installallation

SQL Server 2005 Cumulative Update 5 for Service Pack 2 - available for download with a request to CSS!

Published 24 December 7 4:42 AM | SSQA.net

From the series of the SQL Server 2005 Service Pack2 Cumulative Update packages blogs and for instance we blogged about SQL2005SP2CU5 earlier, it is available to download now and before that there is a catch to obtain this package. It is not that easy...

Filed under: sql server, package, msdn, microsoft, blogs, support, service pack2, testing, online, cumulative update, pss, css, installallation