Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jafrywilson
Constraint Violating Yak Guru
379 Posts |
 Posted - 2010-10-15 : 08:06:27
|
| Hi all.. I want the details of queries and their execution time..while using cursor take more time but by joining the tables we can easily get result .So only i am asking about the timings of queries.. |
|
|
Sachin.Nand
2937 Posts |
Posted - 2010-10-15 : 08:35:56
|
set this command in the query window.set statistics time ongo & then execute your query.PBUH |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-10-17 : 02:25:58
|
| or use profiler to capture the time of query timings using statement started and completed counters.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
jafrywilson
Constraint Violating Yak Guru
379 Posts |
Posted - 2010-10-18 : 02:57:58
|
| Tnx for the replies.. |
|
|
|
|
|
|
query execution