Seth Reply Clint Davis June 8, 2011 6:34 am Thanks for the tip.Blog Architecture Backup and Recovery CHECKDB and Corruption Clients and Case Studies ISV and SaaS Database Design kCura Relativity Stack Overflow Cloud Computing Amazon Web Services (AWS) Google Compute Engine Microsoft Azure Development Adaptive Joins Execution Plans In-Memory OLTP (Hekaton) Load Testing Locking, Blocking, and Isolation Levels Query Store (QDS) SQL Server Management Studio Statistics T-SQL First Responder Kit Hardware Storage High Availability Always On Availability Groups Clustering Database Mirroring Log Shipping How to Think Like the SQL Server Engine Humor Bad Idea Jeans Indexing Columnstore Indexes Index Maintenance Partitioning Licensing Parameter Sniffing Production Database Administration Configuration Settings DBA Training Plan Monitoring Processes and Practices Professional Development Blogging Book Reviews Consulting Consulting Lines Home Office Interviewing Microsoft Certified Master (MCM) Resumes Writing and Presenting SQL ConstantCare Versions (vNext) SQL Server 2016 SQL Server 2017 SQL Server 2019 Videos Virtualization Wait Stats Training My Videos and Downloads My Account Training Classes Private SQL Server Training Training FAQ SQL ConstantCare Consulting Consultant Toolkit Consultant Toolkit Documentation Scripts spBlitz free health check spBlitzCache find queries to tune spBlitzFirst instant performance check spBlitzIndex design the right indexes spBlitzQueryStore analyze queries over time spBlitzWho whats happening right now PasteThePlan share query plans Fixing SQL Server Management Studios Tab Text June 7, 2011 Brent Ozar 82 Comments I hate the way SSMS tabs look by default.The tabs are wide, but they still dont show useful information.
Even worse, Ive got more tabs than I can fit in the window, so the rest hang out in a meaningless dropdown. To fix it, click Tools, Options,and go into Text Editor, Editor Tab and Status Bar. Check out the Tab Text options: Tools, Options You can uncheck the database name, login name, and server name because those are shown in the status bar anyway. Then, if you wanna get fancy, change the status bar location to Top its right above the Tab Text options. ![]() If Im performance tuning, Ill save them as Before.sql and After.sql, or maybe Index1.sql and Index2.sql. Presto, I can easily switch tabs without playing the guessing game. Previous Post How to Design Multi-Client Databases Next Post Scaling SQL Server: Growing Out 82 Comments. Leave new Rich June 7, 2011 8:40 am Hi Brent What would be great is a way to write a macro which would detect when the currently active database or server is on a predefined list and if it is, change the background color of the query window. Thatd be great as a warning that you are on a production database for example. ![]() Select a color. Now when you connect, the status bar (the one you just moved to the top of the editor ) will be that color. ![]() Reply Chris Catignani July 3, 2018 9:59 am OMGThis is a great help. Visual Studio Console Write Not Inserting When Hit Tab How To Do ThatReply Jorge Segarra November 16, 2012 12:33 pm I actually blogged all about how to do that using the toolsmethods Brent described Reply Mike June 7, 2011 8:49 am Thank you. Ive always hated the way tabs worked and this looks much better. Maybe you should rebrand yourself as a SQL decorator Reply AndyG (DBAANDY) June 7, 2011 9:14 am Extreme SQL Makeover Reply Paul Hunter June 7, 2011 8:55 am best damn tip evah Reply Thirster42 June 7, 2011 9:49 am Awesome Reply Shawn Johnson June 7, 2011 9:49 am Awesome tip, thanks Reply Ramon Smits June 7, 2011 10:08 am Seems not to be available for sql server management studeio for sql server 2005 but still a nice tip. Reply Brent Ozar June 7, 2011 10:10 am Ramon yeah, you should be on the latest version of SSMS at all times even if youre connecting to SQL Server 2005. Reply Brad Corbin June 7, 2011 10:33 am Except that the SMS 2008 activity monitor doesnt work against SQL 2000 servers (plus, I dont think its as useful as the SQL 2005 activity monitor). If someone made a classic activity monitor plugin for SMS 2008, Id be all over it Reply David Markle August 31, 2014 5:08 pm And SSMS wont connect to earlier versions of Integration Services. So that sucks. Reply Jason Yousef June 7, 2011 11:39 am Thanks, great tip, Ive been always bothered by the tabs Reply meltondba June 7, 2011 8:54 pm You put your taskbar at the top too How weird I did not know that you could remove the database name from the tab, or that other stuff too. Now I do. Thanks Reply bobi August 20, 2014 8:54 am Task bar on the top very handy. All controls in the same place, dont need to move move though whole screen to manage windows. Reply Muthukkumaran kaliyamoorthy June 8, 2011 1:06 am Thanks for the tip.bernt Reply Seth Lynch June 8, 2011 4:12 am Thanks Brent didnt know I had a problem until you came up with this solution.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2020
Categories |