| Author: Lalji 02 Nov 2009 | Member Level: Diamond | Rating:  Points: 2 |
Twelve Tips For Optimizing Sql Server 2005 Query Performance
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
more info
---------
http://blog.sqlauthority.com/2008/05/21/sql-server-2005-twelve-tips-for-optimizing-sql-server-2005-query-performance/
http://www.c-sharpcorner.com/UploadFile/john_charles/QueryoptimizationinSQLServer200512112007154303PM/QueryoptimizationinSQLServer2005.aspx
|
| Author: Melchior 02 Nov 2009 | Member Level: Gold | Rating: Points: 2 |
The SQL Server Performance depends on two factors. They are
Creation of Execution plan and
Execution of SQL queries based on the execution plan
So you need to pay attention on both factors.
Regarding Execution plan:
http://www.codeproject.com/KB/database/sql-tuning-tutorial-1.aspx
Regarding Query:
http://www.devshed.com/c/a/MySQL/SQL-Performance-and-Tuning-Considerations/3/
|