July 31, 2008 at 9:37 am
Hello,
my select query is running slow can any one tell the steps to slow please.
Regards,
sathish.
July 31, 2008 at 9:37 am
Can you post up the query and table defs ? then you should get some help..
July 31, 2008 at 9:56 am
Check out the links in my signature and if you follow the advice in those articles you should get some good help and going through the process may actually help you come up with a solution.
First thing to do when having performance issues is to run the query in SSMS with view actual action plan on and see what is the biggest performance issue with query(Step with highest %). Fix that, which may mean index creation or re-writing the query.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 31, 2008 at 12:01 pm
As several people have already posted, that's just too vague a question to give you a good answer. If you're really stuck on how to get started, here's a basic introduction[/url].
"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 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply