Browse by Tags

Failed to claim unused space with SP_SPACEUSED?

Published 31 August 7 4:9 AM | SSQA.net

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...

Filed under: sql server, database, dbcc, dba, space, table, transact sql, data type, delete

Database consistency checks and transaction log is filing up, help?

Published 9 May 7 6:40 AM | SqlServer-QA.net (SSQA)

Yet anothe forums related question I would like to blog, as I have seen in my experience on newsgroups. There will be always a question asking about why Transaction log is filling up and blocking is ocurred when a DBREINDEX & CHECKDB processes are...

Filed under: sql server, performance, transaction log, dbcc, trace, search, concurrency, dba