Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
hjbavaliya
Starting Member
1 Post |
 Posted - 2011-01-25 : 05:13:43
|
| hi to alli want to know abt how to improve database performance by some ways to write query or other.if you have tips to how effectively querying database and improve performance and speed of database and what thins to be needed to enhance performance of database....Thanx in advance.......hjbavaliya[url]http://www.hiteshbavaliya.com[/url] |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2011-01-25 : 06:35:44
|
| Entire books have been written on the subject. Try Grant Fritchey's SQL Server Performance Tuning Distilled.At a high level, write queries so that they can use indexes (sargable predicates, simple queries, filtering and joining in the DB, not the application). Create indexes to support the queries.--Gail ShawSQL Server MVP |
 |
|
|
|
|
|
how to improve performance of sql?