#Microsoft sql studio management code
#Microsoft sql studio management windows

Under Object Explorer, Commands, I change “Surround object names with brackets when dragged” to False. I always click the generate-scripts button, but strangely, you can’t even generate scripts when a table re-creation would be required. Under Designers, I uncheck the box “Prevent saving changes that require table re-creation” because I never just hit save when I make changes in a designer anyway. I’m just really comfortable with Control-R to hide the results pane. (Man, does my job suck sometimes.)Ī lot of presenters like to check the box for “Display results in a separate tab” and “Switch to results tab after the query executes” because this gives them more screen real estate for the query and results. Under Query Results, SQL Server, Results to Grid, I change my XML data size to unlimited so that it brings back giant query plans. I would just like to point out that no, I do not set my deadlock priority to high. Under Transact-SQL, General, I check the box for “Line numbers.” Query Execution, Advanced SSMS defaults to tabs, and so I switch it to “Insert spaces.” Insert religious flame war here. Anyhoo, moving on to All Languages, Tabs: Losing my religion I don’t set mine up that way, but I can see why people do, and if you’re reading this post, you’re probably interested in that option.

#Microsoft sql studio management code

The really cool part is when you hover your mouse over the scroll bar map on the right, you get a little zoom popup so you can see a preview of the code at those lines: Zooming on the scroll bar I don’t find that all that useful, so I don’t enable it, but if you’re the kind of person who has long stored procs, you might. The default behavior is bar mode, but if you change it to map mode, you get a text map down the right hand side scroll bar. Next up, going back a little in Text Editor, go to All Languages, Scroll Bars: Scroll Bars Check out how many more tabs you can fit on a screen: Tabs, compacted Scroll down to “Tab Text” and set everything to False except for “Include file name.” When you click OK, it doesn’t take effect on existing tabs, but after you close & reopen them – ahhh, much more legible. Speaking of which, those default tabs are hideous – go to Text Editor, Editor Tab and Status Bar: Editor Tab and Status Bar I save that tab with a recognizable query file name, and then when I pin it, it pops up to the top in that separate row.

#Microsoft sql studio management windows

I love that for frequently-used tabs – I might have a dozen query windows open, but I keep coming back to, say, the window with sp_WhoIsActive open. Under “Tabs and Windows,” check the box for “Show pinned tabs in a separate row.” This way, when you click the pushpin on a given tab, he pops up to the top like this: Pinned tab I like to open a query window too, though – after all, I’m probably opening SSMS to run queries. On startup, SSMS defaults to just opening Object Explorer. If I was you, though, dear reader, I’d set these up.

I’m constantly jumping into an SSMS on someone else’s desktop, and they won’t have the shortcuts set up, so I don’t wanna develop muscle memory for something I won’t have access to. I don’t – but it’s only because I have a wacko job as a consultant. On the Query Shortcuts screen, you should set up shortcuts for the scripts you run most often. However, when I did screenshots for presentations or clients, people kept asking, “Why does your SSMS look so weird? Is it because you’re on a Mac?” These days, I leave those options at their defaults. There are all kinds of “best programming fonts” articles out there with great-looking fonts. On the Fonts and Colors options, I used to get fancy. On the Documents options, I uncheck “Check for consistent line endings on load” because I constantly get scripts with all kinds of wacko line endings. Here are some of my favorites: Documents options Ever go into Tools-Options? SSMS has a stunning number of options these days.