2018-07-19T09:31:00Z

What needs improvement with SQL Server?


Please share with the community what you think needs improvement with SQL Server.

What are its weaknesses? What would you like to see changed in a future version?

Guest
1010 Answers

author avatar
Top 5Real User

In terms of improvement, it could use more integration with other products.

2020-04-19T07:40:00Z
author avatar
Top 5LeaderboardReal User

I would like to have more replication scenarios.

2019-09-22T17:46:00Z
author avatar
Top 20Real User

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. I know that they are building SQL Server for the Unix environment, which is in the beta version, and not out yet. This has been a long time wish for a lot of people. Once that is out, we'll be able to tell how diversified they have become in regards to other platforms. It hasn't 100 percent on scalability and third-party plugins.

2019-03-24T08:52:00Z
author avatar
Consultant

Every good tool has its own limitations. * First of all its cost. It is very high. * We need a good amount of RAM to properly use this. * Sometimes, query sticks in between. But our organization provides great RAM, so we don't have any issue with its speed.

2019-03-07T09:15:00Z
author avatar
Top 10Real User

Horizontal partitioning. In that case, cold , warm and hot data can be distributed into different database not only table partition located on different FGs .

2019-02-15T03:06:00Z
author avatar
Real User

I would like a mature real-monitoring built in into SSMS, even a trace file analyzer.

2019-02-13T15:52:00Z
author avatar
Top 5LeaderboardReal User

* It does not scale up to a truly global environment. We operate in 220+ countries and territories with data services centralized in three data centers. The ability for MS SQL to operate in this environment is a challenge for anything spanning regions or having a global footprint. * It is best suited to supporting a single functional instance by business domain or a single country. * MS needs to work better at the WAN implementations transoceanic. * It also needs to have a less closed or less MS centric tool dependency as integration with other databases and non-MS development environments is always problematic.

2018-11-19T01:28:00Z
author avatar
Real User

It would be nice to search for specific value across multiple tables. This would save a lot of time.

2018-11-18T07:31:00Z
author avatar
Real User

* Third-party services from Redgate should be built-in to it, like SQL Search. * Debugging from the debugger tool functionality should be enhanced.

2018-08-10T00:57:00Z
author avatar
User

Improvements to the indexing, columnstore indexing, and high availability groups are good improvements for future versions.

2018-07-19T09:31:00Z
Learn what your peers think about SQL Server. Get advice and tips from experienced pros sharing their opinions. Updated: August 2020.
441,672 professionals have used our research since 2012.