SQL Server Pros and Cons
SQL Server Pros
It is one of the most stable relational databases out there.View full review »
Tuning Advisor suggests where to add indexes and from where to remove them. It works like an adviser.
SQL Server Profiler makes finding and debugging easy.
I use it to fine tune my procedures and functions.View full review »
I have experience with this product for many years. I never have problems with it. It can handle a PC, and it can also handle huge data. It is fast and efficient.View full review »
This solution has proven stability and operational power.View full review »
The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations.View full review »
SQL Server Cons
I would like to see native plugins built for other platforms versus having to buy third-party plugins to tap into S3 buckets and AWS Cloud. Right now, it does not have those built-in plugins.View full review »
Third-party services from Redgate should be built-in to it, like SQL Search.
Debugging from the debugger tool functionality should be enhanced.View full review »
It would be nice if there was a feature to search for a specific value across multiple tables. This would save a lot of time for its users.View full review »
Improvements to the indexing, columnstore indexing, and high availability groups are good improvements for future versions.View full review »
I would like to have more replication scenarios.View full review »