0
votes
0answers
206 views

Unique index failed?

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 ...
0
votes
1answer
81 views

advice on database index maintenance

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 ...
0
votes
1answer
361 views

in MSSQL Server 2005 Dev Edition, I faced index corruption

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: ...
1
vote
2answers
912 views

How to fix a table with a single bad record (or a corrupt index)?

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 ...
3
votes
1answer
862 views

Why won't SQL Server use an index seek when running a parameterized query?

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