Browse by Tags

FIX: The performance of insert operations against a table that contains an identity column may be slow in SQL Server 2005

Published 11 August 7 5:15 AM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications FIX: The performance of insert operations against a table that contains an identity column...

Filed under: sql server, performance, database, kba, insert

SQL Server 2005 unable to shrink the transaction log, help? (peculiar issue)

Published 15 June 7 5:19 PM | SSQA.net

On one of the archive database (using SQL 2005) we have a monthly task to shrink the transaction log during every 1st week of the month, this is required due to clear up the space on one of the drives where the additional transaction log file located...

Filed under: sql server, performance, database, transaction log, kba, article, shrink