SQL Optimization
- Review Isolation Levels - Use Of Dirty Read Can Enable ‘Light Scans’ For DSS
- Consider The Use Of INSERT CURSORS
- Apply Suitable Data Types - Strings Vs Numeric
- Are You Running UPDATE STATISTICS?
- Don’t Be Afraid To Use ‘SET EXPLAIN’ Xtree Tool & Time Your SQL