Okay, so you have a corrupted index. I know, it never happens in MSSQL, so I guess this is just a proof-of-concept thingie. First let’stake a quick peek at your index, just to make sure this is a complete waste of time: SELECT a.index_id, name, avg_fragmentation_in_percentFROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS aJOIN sys.indexes [...]
