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


  Modified On Nov-29-2017 09:22:45 PM

Leave Comment