What are the steps to tune the SQL Queries?

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

, +

I have a report queriy, which returns bulk of data( around 20k) if i take a report for 1 month. But the query itself is taking much time to show the result.The query contains lot of sub queries,i know if we use sub queries , the output will be in a slow manner. So i have changed all the sub queries to joins(mainly "Inner join","Left Join" ). Still there could be done some more tuning. Any one can suggest me how to tune the SQL queries? Please let me know the steps. In what are all the way we can improve the performance of SQL Queries?

Posted 29-Jul-14 22:57pm

Sibeesh Venu

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Nirav Prabtani** · Answer 1 · 2014-07-29T23:10:00

Solution 1

refer this.. :)

How To: Optimize SQL Queries[^]

SqlServer Query Optimization Tips[^]

Query Optimization Tips[^]

SQL Tuning/SQL Optimization Techniques:[^]

SQL SERVER – Tips for SQL Query Optimization by Analyzing Query Plan[^]

Top 10 steps to optimize data access in SQL Server: Part II (Re-factor TSQL and apply best practices)[^]

The Baker’s Dozen: 26 Productivity Tips for Optimizing SQL Server Queries (Part 1 of 2)[^]

Tips, Tricks, and Advice from the SQL Server Query Optimization Team[^]

Posted 29-Jul-14 23:10pm

Nirav Prabtani

Comments

[no name] 30-Jul-14 5:13am

Lots of links mate :(

Thanks7872 30-Jul-14 6:19am

So what? You have to learn it as there is no magic way to resolve it.

Nirav Prabtani 30-Jul-14 6:23am

:)

[no name] 30-Jul-14 8:36am

My +5 Nirav, Nice links.