SQL Server Management Studio is a great all-round tool for SQL Server
Rating: 10 out of 10
IncentivizedUse Cases and Deployment Scope
We manage almost everything about our various SQL Server databases using SQL Server Management Studio. We perform all of our manual queries in SQL Server Management Studio, we use it for drafting new functions and stored procedures, we use it to create tables, views, constraints, and triggers, we use it to create SQL Agent jobs and manage them, we use it to examine execution plans,and much more.
Pros
- Intellisense
- Execution plans
- SQL Agent management
Cons
- I have always been bothered by the way the list of stored procedures in the Object Explorer have dbo prepended, so that you cannot use keystrokes to easily jump to a particular file
- Occasionally an open query window loses its connection
- It can be slow to open certain files (e.g. when using Script Stored Procedure As)
Likelihood to Recommend
The tool is excellent for managing virtually all aspects of SQL Server - multiple servers, databases, hundreds of tables and procedures, dozens of SQL Agent jobs. We have not encountered any situations where it is not appropriate.
