This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am showing a SSMS option to set the ROWCOUNT for getting the fixed number of records by all SQL Query for SQL Server.
If you are aware of MySQL Workbench, it also returns only top 1000 default rows for all query results.
SQL Server SSMS also has this kind option to set default ROWCOUNT of query results.
The main advantages to set this option,
If a table has millions row and someone is executing this without knowing about this, it requires more memory resource to produce results into SSMS.
You can set an option from menu Tools -> Option -> Query Execution -> change value of SET ROWCOUNT.
After setting parameter, you can execute the SELECT command on any tables and it returns only 10 rows in the result window.