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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Bytes in a query result size

Author  Topic 

BigApple
Starting Member

3 Posts

Posted - 2003-11-06 : 18:29:24
Hi,

Is there a way to determine the size of a query result size i.e th enumber of bytes in the query result size?
It would be something like no of rows * size of each row. Is there a stored procedure which determines the statistics associated with queries, such as the number of bytes delivered, etc?


thanks in advance,
BigApple

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2003-11-06 : 18:38:37
In query analyzer you can set "Show client statistics" and it will show you the number of bytes received. I think that is a function of query analyzer though and not one of SQL Server. I could be wrong there.



Damian
Go to Top of Page
   

- Advertisement -