SQL Server Performance Forum – Threads Archive
index tuning stored procedures
Hello AllI 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
SQL-Server-Performance.com 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 thishttp://msdn2.microsoft.com/en-us/library/ms173448.aspx link fyi. Satya SKJ
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>