Web Development

Ask something
Question Locked

Data tunning

0 helpful
2 replies

by meti.mkumar

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

What are the basic steps we have follow in imporve the performance of one T-sql query or Stored procedures ?

Any one can plz help me plz

2 replies

by tony hopkinson

Here's good start

http://www.sql-server-performance.com/transact_sql.asp

There are lot's of considerations, and no real way of pointing the direction you might need to go now, for a specific case without a specific query to tune.

Learning what the show plan functionality in the MS SQL Query Analyser tool can do for you is a good start.
Best bet is to write some 'bad queries' and see waht the tool says, then optimise it and see what show plan says now. You get to recognise problem patterns which then suggest 'simple' improvements.

This discussion is closed to new replies.