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 |
|
nstsuri
Starting Member
8 Posts |
 Posted - 2013-06-04 : 12:06:07
|
| any chance we can get the report of the top 10 with the most records returned?Thanks,irus |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-04 : 13:06:17
|
| you mean top 10 queries or top 10 table based on record count?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
nstsuri
Starting Member
8 Posts |
Posted - 2013-06-04 : 13:59:19
|
| Hi,I am looking for top 10 Queries.thanks,IRUS |
|
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-06-04 : 15:19:25
|
quote:
Originally posted by nstsuri
Hi,I am looking for top 10 Queries.thanks,IRUS
You can get a variety of TOP N queries using the standard reports. In SSMS right click on the server name in object explorer and look up Reports -> Standard Reports. But there is no standard report that returns the queries ordered by the number of rows returned. |
|
|
|
|
|
|
Top 10 with the most records returned