- Have enough indexes to make your queries fast, but not so many that they slow down delete/update/insert operations. (I cover that in the Mastering Index Tuning class.)
- Use the right isolation level for your app’s needs. (I cover that in the Mastering Server Tuning class.)
- Tuning your T-SQL to work through tables in a consistent order and touch them as few times as possible.
I’ll cover #3 in a one-hour webcast with Quest Software on Thursday at noon Eastern. Register here.