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 |
|
joni
Yak Posting Veteran
50 Posts |
 Posted - 2007-02-21 : 13:27:20
|
| Hi Gurus,In the "Query Analyzer" exist a option named "Query". This option have another sub-options. One of that option is "Index Tuning Wizard" but is disable. How can I put this option enable.Thanks,Joni |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-02-21 : 13:31:02
|
| You first need to have a query written in the query window. I prefer not to use the Index Tuning Wizard though. If you'd like for us to tell you what indexes we think you should have for a particular query, feel free to post it here.Tara Kizer |
 |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2007-02-21 : 13:31:12
|
| Are you a member of the sysadmin fixed server role? If not, you can't use it.CODO ERGO SUM |
|
|
|
|
|
|
Index Tuning Wizard