Sunday, November 1, 2009

My favorite SQL Server Management Studio settings

I work a lot with SQL Server Management Studio (SSMS). From a performance perspective I'm not so happy with the default settings of this application. Therefor I made some changes to the settings of SSMS.
To made changes to the setting of SSMS start SSMS and select Tools, Options in the menu.

  1. Startup with an empty environment. (Environment, General, At startup: Open empty environment)
  2. To avoid to lock other users when you execute long running SELECT queries. Set the default transaction isolation level to: READ UNCOMMITTED (Query Execution, SQL Server, Advanced, SET TRANSACTION ISOLATION LEVEL)
  3. Include column headers when copying or saving results. (Query Results, SQL Server, Result to Grid)
  4. Quote strings containing list seperators when saving to .csv results. (Query Results, SQL Server, Result to Grid)
  5. Word wrap. This is a setting which I changed a lot depending on the kind of queries I'm analyzing. (Text editor, Plain Text, General, Settings)
Enjoy using SSMS


markson said...

Preparing and enrolling for the test costs, however frequently bosses either pay for this as a speculation or help with a level of the assets. They realize it is a significant speculation. ExcelR PMP Certification

digitaltucr said...

There's no doubt i would fully rate it after i read what is the idea about this article. You did a nice job..
ExcelR pmp certification

Priyanka said...

Attend The PMP Training in Bangalore From ExcelR. Practical PMP Training in Bangalore Sessions With Assured Placement Support From Experienced Faculty. ExcelR Offers The PMP Training in Bangalore.
ExcelR PMP Training in Bangalore

PMP Certification Bangalore said...

This PMP certification program in Bangalore follows a structured approach and commences with an introduction to project management concepts. Learn core concepts and pick amazing exam tips at the PMP certification training in Bangalore.
PMP Certification Training in Bangalore