Tuesday, May 27, 2008

12 Tips for Optimising SQL Server 2005 Queries

1. Turn on the execution plan, and statistics

2. Use Clustered Indexes

3. Use Indexed Views

4. Use Covering Indexes

5. Keep your clustered index small.

6. Avoid cursors

7. Archive old data

8. Partition your data correctly

9. Remove user-defined inline scalar functions

10. Use APPLY

11. Use computed columns

12. Use the correct transaction isolation level


A well written article to jog the memory when writing TSQL >

http://tonesdotnetblog.wordpress.com/2008/05/26/twelve-tips-for-optimising-sql-server-2005-queries/

No comments: