Browse by Tags

All Tags » sql server » kba » index (RSS)
FIX: Error message when you try to delete some stored procedures concurrently in SQL Server 2005: “Temp table deferred drop doesn't scale for certain workloads”
Published 7 October 7 7:32 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 Notification Contents: New and All Modifications FIX: Error message when you try to delete...
Filed under: , , , , , ,
FIX: Error message when you try to update the index key columns of a non-unique clustered index in SQL Server 2005: "Cannot insert duplicate key row in object 'ObjectName' with unique index 'IndexName'"
Published 14 August 7 5:28 PM | SSQA.net
Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications FIX: Error message when you try to update the index key columns of a non-unique clustered...
Filed under: , , , , ,
FIX: A database is marked as suspect when you update a table that contains a nonclustered index in SQL Server 2005
Published 8 July 7 7:14 AM | SSQA.net
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 FIX: A database is marked as suspect when you...
Filed under: , , , ,
FIX: When you run the "dbcc dbreindex" command or the "alter index" command, some transactions are not replicated to the subscribers in a transactional replication in SQL Server 2005
Published 22 May 7 12:54 PM | SSQA.net
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition KBA - FIX: When you run the "dbcc dbreindex" command or the "alter index" command, some transactions are not replicated...
Filed under: , , , , ,