Browse by Tags

• 823
• 8966
• checkdb
• corrupted
• dbcc
• Hardware
• insert
• kba
• page
• SQL Server
• sysindexes
• table
• updateusage

• Error: Could not find row in sysindexes for database. 8966, 823 and 602

  Long ago, not long ago.... No doubt that many of you might have gone through the error above within your SQL environment, also I see many forum posts out there to resolve the issue. The bottom line of this issue is Hardware and no other issue can contribute Read More... Posted Tuesday, August 14, 2007 7:35 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, Hardware, database, table, corrupted, dbcc, sysindexes, 8966, 823, page, checkdb

• How to get updated page or row count information for the current database?

  DBCC UPDATEUSAGE (0); GO Best practice to use DBCC UPDATEUSAGE i ntermittently and must if you have upgraded the database from SQL 2000 to 2005. The usual working fashion of this DBCC statement is to correct the rows, used pages, reserved pages, leaf Read More... Posted Tuesday, August 14, 2007 12:00 AM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, database, dbcc, updateusage

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

  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 Read More... Posted Saturday, August 11, 2007 8:15 PM from SSQA.net | (Comments Off) Filed under: SQL Server, performance, database, kba, insert