• That could be achieved like this: http://www.google.be/search?hl=nl&source=hp&q=database+tuning+advisor&btnG=Google+zoeken&meta=&aq=f&oq=&sourceid=Mozilla-search

    which might eventually get your to http://msdn.microsoft.com/en-us/library/ms166575.aspx

    stating

    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.

    ....

    et voila :hehe:

    Johan

    Learn to play, play to learn !

    Dont drive faster than your guardian angel can fly ...
    but keeping both feet on the ground wont get you anywhere :w00t:

    - How to post Performance Problems
    - How to post data/code to get the best help[/url]

    - How to prevent a sore throat after hours of presenting ppt

    press F1 for solution, press shift+F1 for urgent solution 😀

    Need a bit of Powershell? How about this

    Who am I ? Sometimes this is me but most of the time this is me