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 |
|
mirza21
Starting Member
11 Posts |
 Posted - 2009-04-01 : 05:58:48
|
| hi friend i am new to sql language. i want to have knowledge about internal working of query. so tell me if there is any software or utility with which i can analyse how query is executed and data is retreived from tablethanks |
|
|
godspeedba
Yak Posting Veteran
90 Posts |
Posted - 2009-04-01 : 06:54:40
|
| tools-> sql query analyzer |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-04-01 : 07:39:32
|
| Read SQL Server Books Online, search for "query optimizer" and "query processing". There are also options in Query Analyzer and SQL Server Management Studio to display the actual plan of the query. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-01 : 12:54:18
|
| use show execution plan option available in query analyser and also profiler to trace the query running |
|
|
|
|
|
|
tool to analyze query?