CODEWITHSUNDEEP
sqlsql-server
user728584
user728584

Reputation: 2135

SQL Server Query Size of Results Set

Is there anyway in SQL Server to determine the size in MEGS of data that a query returned in a query from Mgmt Studio in the Result Set?

Upvotes: 12

Views: 14160

Answers (2)

niktrs
niktrs

Reputation: 10066

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

SELECT *
INTO tablename
FROM ...

Exec sp_spaceused 'tablename'

DROP TABLE tablename

Upvotes: 8

Will A
Will A

Reputation: 25008

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.

Upvotes: 29

Related Questions