Browse by Tags

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

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

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

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