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 |
|
whiteblue
Starting Member
4 Posts |
 Posted - 2012-03-13 : 10:17:19
|
| what is the peformance tuning?top 10 tips to get exact results for a sql query ? |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-13 : 10:26:29
|
| Performance tuning is the process of making queries (or entire applications) run faster.Top 10 tips for what?--Gail ShawSQL Server MVP |
 |
|
|
whiteblue
Starting Member
4 Posts |
Posted - 2012-03-13 : 10:44:51
|
| to get exact result of any query with fast........i mean to ask what are rules example we should not write * in select statement ......we can choose cloums ..... |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-13 : 10:52:35
|
| Huh? Don't understand.--Gail ShawSQL Server MVP |
|
|
|
whiteblue
Starting Member
4 Posts |
Posted - 2012-03-13 : 10:59:08
|
| sir my question iswhat will u consider to get fast and exact result for a sql query?example should we use joins / procedure/ views are anyyyyy u know more copmare to me?can u send u r mail id...... |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2012-03-13 : 11:52:51
|
| General rules for efficient SQL:Return just what data is neededWrite queries so that SQL can use indexesCreate indexes to support the queriesWrite code that is as simple as possible.Run performance tests against production data volumes, tune the queries if they don't meet the requirements.For details, maybe get Grant Fritchey's book: SQL 2008 Query Performance Tuning Distilled.--Gail ShawSQL Server MVP |
|
|
|
|
|
|
sql tuning