What can cause poor performance of a query? Any or a combination of these:
- No indexes exist for the tables
- Unnecessarily complicated joins
- Excess usage of cursors
- Excess usage of temporary tables
- Stored procedures being recompiled excessively
- Procedures or triggers without SET NOCOUNT ON