Default size of results window SQL Server Management Studio or alternative

Any one who uses SQL Server 2008, or earlier variants, knows that when you run the commands in the wi开发者_StackOverflowndow the results window pops up for the lower half of the screen. I do want to see my results but when only the first or top 10 results will do have the window is a waste. Is there a way I can change the default size of that window?

Also if this kind of functionality exists in VS 2008 or 2010 let me know and I'll abandon SQL Server Management Studio.

Tools -> Options -> Environment -> Fonts and Colors -> Grid Results

There's no way to change the default size of the results pane. You may want to try sending your results to a separate tab instead. You can adjust this setting for both Results to Grid and Results to Text.

Under the Tools -> Options menu:

can't you just use this:

set rowcount 10

And you will only get the first 10 lines of your result.

It's the second time that I'm searching for an answer to the exact same irritant and although the results tab, proposed by Joe Stefanelli, isn't a bad option, I found the actual way to fix this.

I'm on SSM 2017 and all you have to do is pop your query out of your SSMS interface. In other words, say your SSMS is open on your primary screen, you click on 'New Query', a 'SQLQuery1.sql' window opens, then u click and drag that tab out of SSMS on your secondary screen. From then on, after rolling your first query, simply adjust the results pane to the desired size and it'll remain at that size the next time you execute.

You're welcome! <(^-^<)