Bits of .NET

Even with indexes, your DB can slow down due to Fragmentation. This happens after many Inserts/Deletes.

The Pro Check: Run this to rebuild all indexes on a table and reclaim performance:

ALTER INDEX ALL ON MyTableName REBUILD;