Browse by Tags

• 823
• 8966
• checkdb
• corrupted
• data type
• dba
• dbcc
• delete
• Hardware
• page
• performance
• space
• SQL Server
• sysindexes
• transact sql

• Failed to claim unused space with SP_SPACEUSED?

  Recently I have been stumped by not cliaming unused space correctly even though after delete handful of rows on a table. You may be aware using SP_SPACEUSED will get you details such as : Column name Data type Description database_name nvarchar(128) Name Read More... Posted Friday, August 31, 2007 7:09 PM from SSQA.net | (Comments Off) Filed under: SQL Server, database, table, dba, dbcc, space, transact sql, data type, delete

• 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