SQL Server Query Size of Results Set

Is there anyway in SQL Server to determine the size in MEGS of dat开发者_运维技巧a that a query returned in a query from Mgmt Studio in the Result Set?

You can turn on client statistics (Query menu, Include Client Statistics) which gives number of bytes returned from the server when the query is executed.

Create a table with query results and run sp_spaceused against it.

SELECT *
INTO tablename
FROM ...

Exec sp_spaceused 'tablename'

DROP TABLE tablename