articles

Home / DeveloperSection / Articles / Discard results after execution SSMS

Discard results after execution SSMS

AVADHESH PATEL 7307 11-Sep-2012

This is a SSMS (SQL Server Management Studio) option that use for discard results after execution. When enabled this option will discard results after the execution. The advantage of disabling the option is that it will improve the performance by using less memory, because it not returns string like confirmation message, output etc.

Disable discard option
-- USE DATABASE

USE AVI
 
--SELECT RECORD FROM TABLE
SELECT * FROM INFO 
Screen Shot

Discard results after execution SSMS

Enable discard option

For enabling this option first open new tab of SSMS, then go to Tools >> Options >> Query Results > SQL Server >> Results to Grid >> Discard Results After Execution.

Now execute any query. For demonstration I execute SELECT query.

Discard results after execution SSMS

Note: in both case if we check execution time that are dissimilar when table have heavy data.

Discard results after execution SSMS



Updated 07-Sep-2019
Avadhesh Kumar Patel District Project Manager - Aligarh 14 months work experience in Panchayati Raj Department Sector as District Project Manager & 12 months work experience in IT Sector as Software Engineer. :-)

Leave Comment

Comments

Liked By