---
title: "Discard results after execution SSMS"  
description: "This is a SSMS (SQL Server Management Studio) option that use for discard results after execution. When enabled this option will discard results after"  
author: "AVADHESH PATEL"  
published: 2012-09-11  
updated: 2019-09-07  
canonical: https://www.mindstick.com/articles/1000/discard-results-after-execution-ssms  
category: "database"  
tags: ["database"]  
reading_time: 1 minute  

---

# Discard results after execution SSMS

This is a SSMS (SQL [Server Management](https://www.mindstick.com/interview/33968/how-to-clear-the-cache-in-sql-server-management-studio-ssms) 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](https://www.mindstick.com/forum/157912/what-is-regularization-how-can-it-be-used-to-improve-the-performance-of-a-machine-learning-model) by using less memory, because it not returns string like [confirmation message](https://www.mindstick.com/forum/12802/show-confirmation-message-yes-or-no-in-asp-dot-net), output etc.\

##### Disable discard option

#####

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

![Discard results after execution SSMS](https://www.mindstick.com/mindstickarticle/9c50d77a-de29-43c0-a046-6e8be92afd39/images/171bf4c4-0d66-41e9-a4dd-e67456e08051.png)

##### 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](https://www.mindstick.com/mindstickarticle/9c50d77a-de29-43c0-a046-6e8be92afd39/images/6ea8881d-e038-45db-9f33-48e35926ec12.png)

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

![Discard results after execution SSMS](https://www.mindstick.com/mindstickarticle/9c50d77a-de29-43c0-a046-6e8be92afd39/images/312533d9-4076-45c5-a91d-da19c812c148.png)

\

---

Original Source: https://www.mindstick.com/articles/1000/discard-results-after-execution-ssms

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.