how to show process in query of sqlserver 2005
-
Hello everyone, I have simple query as: SELECT so.title,max(so.nu_view) FROM song as so,singer as si GROUP BY so.title,so.nu_view certainly, it will show the result, but to get achievement it needs a performing process, how to view this activity Example: how to see combination between song and singer, how to see "group by" activity ... does SQL server 2005 support this fuction ?
help me
-
Hello everyone, I have simple query as: SELECT so.title,max(so.nu_view) FROM song as so,singer as si GROUP BY so.title,so.nu_view certainly, it will show the result, but to get achievement it needs a performing process, how to view this activity Example: how to see combination between song and singer, how to see "group by" activity ... does SQL server 2005 support this fuction ?
help me
You can use SQL
Server Profilerto check the Performance of your Any Query. :-DAbhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.
-
You can use SQL
Server Profilerto check the Performance of your Any Query. :-DAbhijit Jana | Codeproject MVP Web Site : abhijitjana.net Don't forget to click "Good Answer" on the post(s) that helped you.
oh thanks, but sql server trace rewrite action process, not describe action inside sql server 2005, Example before publish the result , there are many action such as : combination between many tables, action " WHERE" , "GROUP BY" , I want know the its ' detail
help me
-
Hello everyone, I have simple query as: SELECT so.title,max(so.nu_view) FROM song as so,singer as si GROUP BY so.title,so.nu_view certainly, it will show the result, but to get achievement it needs a performing process, how to view this activity Example: how to see combination between song and singer, how to see "group by" activity ... does SQL server 2005 support this fuction ?
help me
Generally speaking your queries are executed (processed) in the following order: 1. FROM 2. ON 3. OUTER 4. WHERE 5. GROUP BY 6. CUBE | ROLLUP 7. HAVING 8. SELECT 9. DISTINCT 10 ORDER BY 11. TOP
"My interest is in the future because I'm going to spend the rest of my life there." - Charles F. Kettering