Recently, we've been having some kind of memory leak in SQL Server. We do have a .NET assembly running to audit our tables, but this has ran for a few years without problems, so I doubt it's the ...
I have a fairly large table, which I have to keep up, with some very, very fragmented indices. This seems to be causing problems with performance. I would like to have neat fresh crisp indices on this ...
When running stored procedures in MSSQL Server, I found it failed and the DBMS (MSSQL Server 2005 Dev Edition) notified that some indexes are corrupted. Please advice me, here below is DBCC logs: ...
I have a single row in a table that seems to be corrupt. It has an identity field called ID, and I can select where ID < 337 or ID > 337, but not ID = 337. I ran DBCC CHECKTABLE and DBCC CHECKDB ...
When I execute the following query in SQL Server 2005 it uses an index seek, as verified by viewing the execution plan. SELECT * FROM Account WHERE Number = '123456789' But when I run the same ...