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.
- Startup with an empty environment. (Environment, General, At startup: Open empty environment)
- 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)
- Include column headers when copying or saving results. (Query Results, SQL Server, Result to Grid)
- Quote strings containing list seperators when saving to .csv results. (Query Results, SQL Server, Result to Grid)
- 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)
1 comment:
Really fine and interesting informative post. I used to be looking for this kind of advice and enjoyed looking over this one. Thank you for sharing.Learn PMP Certification in Hyderabad 360DigiTMG
Post a Comment