InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 03:02:56 GMT20http://www.sqlservercentral.com/Forums/Topic1131567-180-1.aspxThat could be achieved like this: [url]http://www.google.be/search?hl=nl&source=hp&q=database+tuning+advisor&btnG=Google+zoeken&meta=&aq=f&oq=&sourceid=Mozilla-search[/url] which might eventually get your to [url]http://msdn.microsoft.com/en-us/library/ms166575.aspx[/url]stating[i]Welcome to the Database Engine Tuning Advisor tutorial. The Database Engine Tuning Advisor enables you to tune databases for improved query processing. Database Engine Tuning Advisor examines how queries are processed in the databases you specify and then it recommends how you can improve query processing performance by modifying physical design structures such as indexes, indexed views, and partitioning.....[/i]et voila :hehe:Sat, 25 Jun 2011 13:27:51 GMTALZDBAhttp://www.sqlservercentral.com/Forums/Topic1131567-180-1.aspx[quote][b]venugopal.machina (6/24/2011)[/b][hr]what are the features and benifits of database tuning advisor?[/quote]Gosh... look it up in Books Online. Figure out your own answer to the interview/test question. At least Google it! ;-)Sat, 25 Jun 2011 13:15:36 GMTJeff Modenhttp://www.sqlservercentral.com/Forums/Topic1131567-180-1.aspxwhat are the features and benifits of database tuning advisor?Fri, 24 Jun 2011 23:58:44 GMTvenugopal.machina