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 |
|
darius_sutherland
Starting Member
17 Posts |
 Posted - 2008-09-08 : 09:32:44
|
| Never a big fan of wizards and not fully up on how to use the new one in 2005.Ive run a few queries through them and lo and behold it can impreove them, mainly by adding stats or indexes.Is it a good idea to follow the advice or do you guys manually tweak based on what you see.Im curious as to...If I followed the advice given and ran the update, it may speed up the current query but what about other queries in the system, could it have a detrimental effect and then when I tune the other queries would it then effect the other changes committed.Thanx in advanceDwww.state-of-mind.co.uk | www.photographersinbrighton.org.uk | www.sussexweddingphotographers.org.uk |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2008-09-08 : 10:37:21
|
| Usually the best way is to think logically about your data and how you are querying it. If you are often filtering on a particular column, then it usually makes sense to index that column in some way. In addition, remember that a large part of optimizing isn't just indexing your tables, but also the database design overall and ensuring that your SQL is efficient.- Jeffhttp://weblogs.sqlteam.com/JeffS |
 |
|
|
darius_sutherland
Starting Member
17 Posts |
Posted - 2008-09-08 : 11:34:39
|
| Okay. Reading up on these include columns.What would you say a general rule would be for these. It's a 2000 DB to 2005 which is why most of the tuning advice is to add these include columns??DState Of Mind Photography - It's This, It's That, It's The Otherwww.state-of-mind.co.uk |
|
|
|
darius_sutherland
Starting Member
17 Posts |
Posted - 2008-09-10 : 10:38:52
|
| No takers on what I thought would be an easy subject.Im still uncertain as to what to index/include. Running the tuner on some of my queries just seems to create e.g another index, which has already been created as a clustered index and more or less all the columns that are retrieved via the query.I don't want to tune the DB for one query, speeding that query up which then in turn has detremantal affects on something else / another query??DState Of Mind Photography - It's This, It's That, It's The Otherwww.state-of-mind.co.uk |
|
|
|
|
|
|
|
|
Trusting Tuning