SQL Q&A: Fine Tuning for Optimal Performance

March 2012

Duplicate indexes, cancelled rollback operations and I/O spikes can cause performance issues, but you can work around them.