Browse Site by Tags - MSMVPS.COM

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”

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 some stored procedures concurrently in SQL Server...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 10-07-2007
Filed under: sql server, kba, index, concurrent, corrupted, workload, temp table

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'"

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 index in SQL Server 2005: "Cannot insert...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 08-14-2007
Filed under: sql server, kba, index, objectname, duplicate, key

FIX: A database is marked as suspect when you update a table that contains a nonclustered index in SQL Server 2005

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 update a table that contains a nonclustered index...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 07-08-2007
Filed under: sql server, database, kba, index, suspect

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

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 to the subscribers in a transactional replication...

Posted to SQLServer-QA.net - Knowledge Sharing Network (SSQA.net) (Weblog) by Anonymous on 05-22-2007
Filed under: sql server, dbcc, kba, transaction, index, dbreindex