Browse by Tags

FIX: Error message when you run a query that references a temporary table in SQL Server 2005: "Internal error. Buffer provided to read column value is too small. Run DBCC CHECKDB to check for any corruption"

Published 19 September 7 5:21 PM | SSQA.net

The following pages were recently modified. 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...

Filed under: sql server, dbcc, checkdb, kba, error log, buffer pool, internal error

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

Published 14 August 7 4:35 AM | SSQA.net

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

Filed under: sql server, performance, database, dbcc, checkdb, table, hardware, corrupted, sysindexes, 8966, 823, page

DBCC CHECKDB flusing the cache!

Published 15 May 7 9:54 AM | SqlServer-QA.net (SSQA)

Well another cache related blog in a row since last few days! I have had weird issues on one of the SQL Server 2005 SP1 instance that, whenever DBCC CHECKDB is executed the performance of particular stored procedure ( complexed calculations ) has gone...

Filed under: sql server, management, ssis, security, ssms, perfmance, cache, flush, checkdb