April 22, 2014 at 11:37 pm
Hi All,
Am Using SQL2008,
I want to Optimize a Query,Where can i check the Recommendations like whether i have to create an index(Clustered/NC).
How to improve the Performance of the Query..
Regards
Jagadeesh....
Regards
Chowdary...
April 22, 2014 at 11:47 pm
Have a look at the Books link, Grant has a great free eBook on SQL server execution plans and how to read them and there's Tim Ford and Louis Davidson's book on performance tuning using DMV's. And even better they provide some scripts taht you can use out of the box to help you.
April 23, 2014 at 3:41 am
Unfortunately, there really isn't any sort of automated method for tuning queries. It's actually somewhat hard work requiring quite a bit of specialized knowledge. The two books down in the links in my signature are very good resources to get you started. If you have specific questions on a specific query, you can always post the query along with the execution plan here on SQL Server Central.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply