ishita

• Jan 3rd, 2006

 

Using the power of the SQL Profiler and running a simple trace to capture the performance of your stored procedures can easily obtain these query lists. that needs tuning.

Vishal

• Apr 5th, 2006

 

You can use Execution Plan in SQL server to see the cost of your querry.By this you can optimised your query.

sahu

 Profile Answers by sahu Questions by sahu

• Mar 29th, 2007

 

Hi,

 First  Excute  Sql Quries in Query Analzer,see How much time 2 take Excute , if Less then the ur desired Time, then it will Optimize query

Pendurti

 Profile Answers by Pendurti 

• Sep 11th, 2008

 

There is something called Query analyzer that u can make use of to find out whether the given query is optimized or not.