SqlServer-QA.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 you would expect are not upto the mark, when using indexing tuning wizard or by updating ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Enterprise EditionNotification Contents: New and All Modifications FIX: The performance of a query that performs an insert operation or an update operation is much ...

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 pack2 release of SQL Server Express 2005 edition. So on the above enabled X64 ...

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 3The index ''<name>'' (partition 1) on table ''TableName'' cannot be reorganized because page ...