Logo Questions Linux Laravel Mysql Ubuntu Git Menu
HTML CSS JAVASCRIPT SQL PYTHON PHP BOOTSTRAP JAVA JQUERY R React Kotlin
 

SQL Server Query Size of Results Set

Tags:

sql

sql-server

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?

like image 367
user728584 Avatar asked Jun 23 '11 06:06

user728584

1 Answers

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.

like image 87
Will A Avatar answered Nov 15 '22 17:11

Will A
Sign in to Comment

Related questions

SQL Multiple COUNT() from two tables, within a LEFT JOIN
Check if datetime is in current date
SQL - Create view from multiple tables
copy tables with data to another database in SQL Server 2008
Create a dynamic mysql query using php variables
Iterating over PyoDBC result without fetchall()
How Do I Use Case Statement Column In Group By
java.lang.OutOfMemoryError: Java heap space with hive
Running a SQL query in the background using MySQL
How to escape underscores in Oracle SQL Developer?
Checking for existence of index in PostgreSQL [duplicate]
Getting around cyclical foreign key errors when trying to generate insert data scripts in SQL 2008
Facebook FQL LIKE operator [duplicate]
SQL - Get Numerical Day of Month/Quarter
TRANSFORM and PIVOT in Access 2013 SQL
How to return NULL when result is empty?
SQL CASE [Column] WHEN IN ('case1', 'case2') THEN 'oops' END?
How to get the Sum of all column values in the last row of a resultset?
casting datareader value to a to a Nullable variable
SQL column count does not match value count error

Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!