Performance Tuning on SQL Server

Performance is one of most important factor at the time of the application developement. If your application or website is not responding fast to user queries then it's accepted by the users.

Here are the some tips to make fast retrival of data from sql server.

1) Create Index- Indexes are great way to improve your performance. It uniquely indetifys the each row in table.

2) Avoid Cursor- Cursors are time consuming so avoid cursors as much as you can do more work with queries.

3) Avoid Joins- Joins are also time consuming so avoid it.

4) Create Primary and Foreign keys in tables

5) Be sure your tables must have atleast one column that uniquely indetifys each rows

 

Published Tuesday, January 29, 2008 10:03 AM by Jalpesh P. Vadgama
Filed under:

Comments

# re: Performance Tuning on SQL Server

Tuesday, January 29, 2008 2:28 PM by Denis The SQL Menace

>>3) Avoid Joins- Joins are also time consuming so avoid it.

??

perhaps you mean avoid joins with more than 4 tables or so. How else will you bring back data from a normalized database

1) Create Index- Indexes are great way to improve your performance. It uniquely indetifys the each row in table.

There is also a fine line here. the more indexes you have the slower your inserts, but your selects will be faster (if your where clause is covered by an index of course)