Some Tips when Optimizing Sql Server 2005 Query

Home >> Dababase Interview Questions >> Sql Server Interview Questions

Posted on May 22nd , 2009 by Admin

Here are some important tips regarding Sql server 2005 query.

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 isola

tion level