Browse by Tags

SQL Server 2008 installation when Visual Studio 2008 is/isn't present?

Published 11 August 8 3:1 AM | SSQA.net

In continuation to the SQL2008-InstallationVows on Windows Server 2008 there was a brief notes on pre-requisite of Visual Studio 2008 Service Pack when you are trying to install the SQL setup. The release notes were bit confusing that you have got with...

Filed under: sql server, release, version, installation, service pack, visual studio, issues, problems

Microsoft Security Bulletin Summary for July 2008 - what is it now?

Published 9 July 8 3:7 AM | SSQA.net

I believe it has been a while that we have seen the security hotfix from Microsoft Security team on SQL Server (alone). The latest security bulletin has announced important security patches that are related to SQL Server in addition to Windows operating...

Filed under: sql server, security, hotfix, service pack, best practice, vulnerability, guidance

SQL Server 2005 Connectivity, Security policies & Network protocols: simple practice to follow, after installation?

Published 23 May 8 3:44 AM | SSQA.net

Secured by default, secured by design is the buzzword and catchy stuff for any Enterprise IT administrators. Then it comes about standards and policies to follow such as ISO , with the recent threats (last 10 years) and vulnerabilities within IT world...

Filed under: sql server, blocking, security, best practices, hotfix, service pack, cumulative update

SQL Server Release Services - Cumulative Update or frequent Service pack releases, which one you favour?

Published 7 May 8 3:26 AM | SSQA.net

Here is the hot news, SQL Server Global Release Services (GRS) has revised their schedule of releasing Service Packs for SQL Server product by stating ' changed approach to Service Packs '. Now the big question how far you can stretch in deploying...

Filed under: sql server, microsoft, high availability, best practices, service pack, cumulative update, releases

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

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

A service pack does not install on a x64-based passive node cluster computer that is running SQL Server 2005

Published 10 February 8 1:7 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications A service pack does not install on a x64-based passive node cluster computer...

Filed under: sql server, kba, x64, clustering, service pack, passive node

TSQL to get SQL Server properties - How do I know which version of SQL Server I'm running?

Published 21 December 7 3:34 AM | SSQA.net

Use the following TSQL SELECT SERVERPROPERTY('Collation') Collation, SERVERPROPERTY('Edition') Edition, SERVERPROPERTY('Engine Edition') EngineEdition, SERVERPROPERTY('InstanceName') InstanceName, SERVERPROPERTY('IsClustered'...

Filed under: sql server, version, edition, license, service pack, tsql, best practice, collation, server property, engine

SQL Server 2005 standard query tuning options - plan guide for performance testing how to?

Published 30 October 7 10:41 PM | SSQA.net

You may be aware that plan guides will help the optimizer to perform better and a general recommendation is to use the relevant USE PLAN query hint when the other standard query tuning options are failed. It is also necessary to test through the results...

Filed under: sql server, performance, indexes, services, hotfix, planning, service pack, best practice, testing, plan guide

How to install service packs and hotfixes on an instance of SQL Server 2005 that is configured to use database mirroring

Published 8 September 7 4:18 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, kba, database mirroring, service pack, configuration

FIX: The performance of a query that performs an insert operation or an update operation is much slower in SQL Server 2005 SP2 than in earlier versions of SQL Server 2005

Published 30 August 7 5:0 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, performance, update, query, kba, service pack, operation

FIX: Error message when you use Database Engine Tuning Advisor to tune a database in SQL Server 2005 Service Pack 2: "An unhandled win32 exception occurred in dtaengine90.exe [4308]"

Published 29 August 7 2:38 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX...

Filed under: sql server, error, kba, service pack, exception, unhandled, dtaengine

FIX: You receive an error message when you try to install the original release version of SQL Server 2005 or SQL Server 2005 Service Pack 1 on a computer that is running Windows Vista

Published 29 August 7 12:31 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications...

Filed under: sql server, windows, kba, vista, service pack, 1

SQL Server Express installation on X64 platform?

Published 28 August 7 6:5 AM | SSQA.net

Can we get install SQL Server Express 2005 edition on X64 environment? Yes and No. Yes for SQL Server Express on X64 and EMT64 that too in Windows on Windows ( WOW ), but No it is not supported on IA64 systems. This enhancement is enabled since the service...

Filed under: application, sql server, performance, x64, service pack, platform

The following KBAs were recently modified for Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition.

Published 16 August 7 3:39 PM | SSQA.net

The following pages were recently modified for Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition. FIX: Error message when you synchronize a subscription by using Windows...

Filed under: sql server, ssis, replication, kba, hotfix, service pack, ftp

Msg: 2522 The index "<name>" (partition 1) on table "TableName" cannot be reorganized because page level locking is disabled.

Published 7 August 7 8:43 AM | SSQA.net

All of sudden the re-org of an index started failing and no error was displayed within that scheduled job we execute. After executing the code from Query Editior I was able to get the message as follows: Msg 2552, Level 16, State 1, Line 3 The index "<name>"...

Filed under: sql server, performance, indexes, service pack, online, allow_page_lock

How to obtain the latest service pack for SQL Server 2005

Published 12 July 7 5:36 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications How to obtain the latest service pack for SQL Server 2005 http://support.microsoft...

Filed under: sql server, server, kba, service pack