Browse by Tags

Cumulative Update 9 for SQL Server 2005 Service Pack 2 - another update package in line
01 September 08 08:05 AM | ssqa.net | with no comments

In continuation to the CumulativeUpdate package posts here for SQL Server 2005 SP2 we have another set of cumulative update package no.9 ready for testing. TO obtain this read the notes from Microsoft: .... Apply it only to systems that are experiencing...

Filed under: sql server, best practices, download, testing, service pack, cumulative update, installation

SQL Server 2008 installation vows on Windows Server 2008
08 August 08 11:14 AM | ssqa.net | with no comments

After I knew about the SQL 2008 RTM release news I have blogged SQL2008RTM-official here and as usual I have attempted to download the setup media from Technet which took a while (3 hours) to download the file, due to the obvious reasons of MSDN/TEchnet...

Filed under: sql server, 2008, windows server, installation, firewall, error

Unable to install SQL Server 2008 RC0 Books Online
01 July 08 06:58 AM | ssqa.net | with no comments

In continuation with the BOL update topic on SQL2008-RC0_BOL post here I have had troubles in installing the RC0 Books Online on to my laptop. As per the error below I thought it may be problem with the Windows Installer service on my laptop (Vista Ultimate...

Filed under: sql server, books online, sample, installation, uninstall, rc0

SQL Server multiple instances and resource utilization - best practices
15 May 08 10:48 AM | ssqa.net | with no comments

A newbie or FAQ within Forums and Newsgroups that having multiple instances and how best to set the resources on the server such as memory, CPU etc. Should you configure each of the instances to use specific portions of the available Operating System...

Filed under: sql server, resources, performance, best practices, installation, multiple, instances, consolidation, virtualization

TSQL to change collation of database, whats new in SQL 2008 then?
12 March 08 08:10 AM | ssqa.net | 1 comment(s)

How can you change collation of a database? How do you check the existing collation setup on a database & tables? By using the below TSQL: --For database select databasepropertyex(db_name(),'collation') as collation_name go --Tables select column_name...

Filed under: sql server, database, tsql, table, change, indexes, setup, collation, installation, constraint, bcp