Home > DeveloperSection > Articles > Discard results after execution SSMS

Discard results after execution SSMS


Database Database 
Ratings:
0 Comment(s)
 4461  View(s)
Rate this:

Discard results after execution – SSMS

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


Don't want to miss updates? Please click the below button!

Follow MindStick