index tuning stored procedures | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

index tuning stored procedures

Hello All
I have a small query . Can we use any stored procedures / queries which can do the task of Index tuning wizard. What I mean is ; Is there any programatical way to do the tasks which index tuning wizard is doing ?

Open the query in SQL Server Managment Studio, point the query in your database, in tools you will find Database Engine Tuning Advisor. This tools work like Index Tuning Wizard 2000. Luis Martin
Moderator One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte
[/size=1] All postings are provided “AS IS” with no warranties for accuracy.[/size=1]
For SQL 2005 may check this link fyi. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.