2018-07-19T09:31:00Z

What needs improvement with SQL Server?

14

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?

ITCS user
Guest
6363 Answers

author avatar
ExpertTop 5Consultant

My experience with SQL Server has been doing database testing with UFT. The main challenge we encountered is finding the correct connection string to use when performing database testing. Other than that, we encountered no issues.

2021-05-02T19:32:20Z
author avatar
Top 20Real User

They can build more performance-tuning tools in it. They can also make the stuff a little more user-friendly and provide the ability to schedule jobs. They can perhaps also streamline it a little bit so that it is not so resource-intensive, which would be helpful. SQL Server has a tendency to consume all the memory you allow it to. If you are not careful, you can basically break your server. I would like to see it having a smaller footprint in terms of system resource consumption. They might want to consider re-evaluating their pricing. It is expensive.

2021-03-30T19:25:39Z
author avatar
Top 5LeaderboardReal User

The way to make cursors and manage raw data in rows can be improved. Currently, the way to construct or build these cursors is very hard, and you can waste memory. You need a highly skilled person to make it more efficient. It can also have support for Cubes, which is the organization of data in different dimensions by using MDX languages.

2021-03-11T01:58:50Z
author avatar
Top 5Real User

It would be better if it had more integration with other systems.

2021-06-18T07:34:42Z
author avatar
Top 5MSP

In terms of exceptionally large databases, it doesn't scale as well as Oracle. It scales excellently and it's flexible and it can provide a solution for exceptionally large databases, but it doesn't work as well as Oracle does for this particular use case. The performance starts to drag in the case of exceptionally large databases; especially where there's a lot more feature functionality. With Oracle, there's a lot more tunability.

2021-06-03T09:43:04Z
author avatar
Top 5Real User

They have too many licensing options. They may want to simplify its licensing and bring it down to two, three, or four categories from ten to fifteen categories. Having so many different licensing options makes it difficult to decide which one to choose from. They can club things together. This is an area where they can make things easier for customers.

2021-06-02T15:44:56Z
author avatar
Top 20Real User

The stored procedure integration with our development could be better. Things are always changing very fast at Microsoft, and it takes a lot of resources to get on top of it. We're struggling with version control. In terms of new features, we don't have any feature requests. We are not focusing on the database.

2021-05-31T15:41:02Z
author avatar
Top 5LeaderboardReal User

If you work with more than 50 gigs of data, it will run slower than Oracle. Security is an area that can be improved. It could be more secure; more security is needed. We have some clients who have been exposed to the SQL injection virus. We would like SQL to be able to manage this problem or to come up with an alerting system to alert the user that the server has been exposed. This has become more of an issue because of the Corona Virus and people are working from home. Some have been infected by the SQL injection Virus and will lose their data.

2021-05-29T17:22:34Z
author avatar
Top 5LeaderboardReal User

The Standard Edition and Enterprise Edition have certain limitations. While the latter is clearly more expensive than the former, it would be nice to see some of the features in the Enterprise Edition be moved to the Standard Edition. This will encourage many more people to use that solution. If we were discussing the 2000 edition in respect of the SQL Server, I would probably cite security and performance as issues. However, nowadays, when it comes to an application connected to their databases, there is no real difference between MS SQL Server and Oracle. As a consequence, it would be nice to see the application be made more cost-effective. I am aware of much database self-management in respect of Oracle. I know that the last time a colleague of mine used this solution in California, he informed me that the application itself was managing the database. At present, the solution uses the older connection and the schema is designed in such a way that it can actually provide a very low level of virtualization. Since the security is also hierarchical within the system, they've really done a very good job. This said, I would like to see the database become fully automated.

2021-05-27T21:04:00Z
author avatar
Top 5LeaderboardReal User

The solution should be more secure and stable and have better performance, particularly as concerns the endpoint operating systems. I would like to have a better operating system that links the CPU and the RAM efficiently. For the majority of our servers we have not used other operating systems, although there are certain features or requirements that necessitated their use, such as Red Hat. This was rare. Mostly, we used Windows OS. As for the performance issue, we have recently encountered situations in which everything would fail in spite of the CPU and memory being 100 percent operable.

2021-05-27T15:16:00Z
author avatar
Top 5LeaderboardReal User

The solution needs to be more secure. It's lacking, compared to, for example, Oracle. The product needs to work on its scalability. Oracle can scale a bit more effectively. Sometimes we have some performance issues. It's not like Oracle. Oracle is more powerful in terms of performance.

2021-05-13T12:18:00Z
author avatar
Top 20Real User

I think the scalability of the database could be improved if it could handle increased volumes of data. I'd also like to see improvement in performance when you are loading big amounts of data. Integration with other solutions would be a nice additional feature.

2021-05-08T15:48:08Z
author avatar
Top 20Real User

Primarily, the data replication and the backup areas can be improved. It should have data replication capabilities and uptime capabilities. The native SQL Server Backups take more time than do the backup processes from LiteSpeed, and the backup compression is a little less.

2021-05-07T23:13:07Z
author avatar
Top 5LeaderboardReal User

The installation process should be simplified. The configuration could be easier.

2021-05-05T14:15:13Z
author avatar
Top 20Real User

Security is an issue. This is an area that needs to be improved. There is security built-in, but most of the developers don't emphasize the security enough. When they are building the products or databases, they don't focus on the security of the database.

2021-04-06T13:38:19Z
author avatar
Top 5LeaderboardReal User

The solution was delivered to us, and we really don't interface with the solution directly. I can't speak to any features that are missing. The only people that can use it directly are developers. It's not for everyday users. The pricing in general could be better.

2021-04-01T10:10:32Z
author avatar
Top 5Real User

We're quite satisfied with the solution. There aren't any outstanding features we would like to add. The interface could be updated to make it slightly more user-friendly.

2021-03-27T19:05:32Z
author avatar
Top 20Real User

Microsoft doesn't have active-active load balancing scenarios. It's always a failover cluster. There is no active-active cluster, which other tools, other database providers like Oracle, provide. If Microsoft can consider or probably come up with an active-active cluster, then it would be good. It will be more powerful in a scenario like that. The pricing, while not the most expensive, is still quite high. They have something called Parallel Queries, however, I don't know how it works. I've never tested it in a horizontal way. I'd like to understand a bit more about it and be able to use it horizontally.

2021-03-06T07:29:37Z
author avatar
Top 5LeaderboardReal User

In my experience, I've found that scalability can be improved.

2021-03-05T16:15:31Z
author avatar
Top 10Real User

The solution is very different from Oracle, which is a product we also use. Mainly the data capacity needs to be improved. The data values are limited. They are smaller or medium scale. The MySQL is working fine, however, when it comes to large data sets or large data volumes, Oracle can handle them better. The backup capacity needs to be bigger.

2021-03-05T09:38:33Z
author avatar
Top 5LeaderboardReal User

Indexing, as well as integration, are areas of this product that need improvement.

2021-02-24T11:06:46Z
author avatar
Top 20Real User

We had some difficulty doing the performance tuning when we migrated from the 2008 version to the 2016 version. We experienced a drop in the performance. We could not understand or figure out what caused the drop in performance. We did not change any settings to cause this effect. We tried to keep the same settings. We feel that when running the 2008 version, it was much quicker in terms of performance. That is an area of SQL Server that can be improved. Moving to a new version, you shouldn't have to change the configuration. We have not been able to utilize it fully because it is not straightforward. I would like to see the performance improved. Migrating should be easier and the scalability needs improvement.

2021-02-18T14:03:20Z
author avatar
Top 5LeaderboardReal User

I would like to see more integration with other products and it needs to be more secure.

2021-02-18T09:56:02Z
author avatar
Top 5LeaderboardReal User

The Message Broker portion of the solution is not very scalable in comparison to the rest of the solution. The problem is, you can exclude that portion. The Task Scheduler has a lot of shortcomings. This could be improved quite a bit. The enterprise version of the product should be more cost-effective.

2021-02-14T14:42:24Z
author avatar
Top 5LeaderboardReal User

It is costly to implement high throughput systems, beyond millions of transactions per second. The hardware to run the systems, especially for high availability deployments is expensive, i.e. more resources to run. Linux-based editions are not yet proven to be on par with Windows deployments. Row-level security is obscure to implement. Running cloud offerings are expensive; for example, the Instance as a Service offering. Third-party tooling is required to manage code version control. Managing BLOB data is not equally simple to implement. The engine that implements query plans was updated in the 2012/2014 refresh that could necessitate a costly rewrite of queries.

2021-02-12T14:21:00Z
author avatar
Top 20Real User

We have had problems implementing a data warehouse using SQL Server. It may be because the data is too big, although it claims to be able to handle the amount of data that we have. Perhaps there are some technical issues because there is something weird going on. It cannot find the correct IP address.

2021-02-11T18:46:53Z
author avatar
Top 5Real User

Better integration with other platforms would be an improvement.

2021-02-11T11:56:34Z
author avatar
Top 20Real User

There should be more tools and documentation for tuning the performance of Microsoft SQL Server. It would be nice to have more tools for tuning because currently, all the tuning that we have to do with our databases is almost manual. We have to read a bunch of knowledge base articles, and this information should be better documented. Its free text search should also be improved. It is quite important for us. Currently, we're developing our own free text search because of the lacking flexibility in Microsoft SQL Server. Therefore, we're kind of using elastic search and making different implementations in order to reach our targets. Using just the native free text search of Microsoft SQL Server is not enough for us. It should have more flexible features as compared to the current version.

2021-02-09T19:41:58Z
author avatar
Top 5LeaderboardReal User

The performance could be better. When we pump in millions of records, we start struggling, and that's why we want improvement in those areas.

2021-02-08T09:45:20Z
author avatar
Top 20Real User

It's night and day if you compare it to Oracle, and I am an Oracle fan. Their datatypes need improvement. The SQL Server language in itself, its datatypes, seem like they are stuck in the eighties. Even companies that work with an SQL Server, experts on J.D. Edwards that sits on SQL Server that handles all the data transformation, they've actually converted the SQL Server datatypes so that they are more useful and easy to handle on their solutions. That tells you right then and there that their datatypes must improve. When you run your SQL optimizer there, on the datatypes, it's very costly because it's just this level of conversion that needs to happen as opposed to just calling it numeric, or as opposed to calling it something else. Their datatypes technically work. If you know what you're doing, it really can give you all that. However, on the optimization side, on the performance side, it does struggle. The datatype conversion to push my data to an enterprise data warehouse is difficult. I can tell you Oracle data is so much easier to ingest into it and it easier than doing it on a SQL Server. There are many issues that I face when I'm pulling data straight from a SQL Server agent. There are more collections that I need to do or handle before it hits my target table. I noticed that due to the fact that I've been working on different databases and ingesting everything in a data warehouse. It just doesn't flow properly. Even on their SQL Studios, that Master Studio tools, even if you try to do your conversions on their own, even though this is their native tool, you're always going to have some problems and it's always going to give you some type of error. It is just difficult to tell you what the error will be. You have to dig in and figure it out. Most of that is due to datatypes. It's just not easy. It's like pulling teeth. Especially if you have had experience using a tool, like Oracle, that is just not that painful. There seems to be a lot of patching, which leads me to believe there may often be stability issues.

2021-02-02T07:46:00Z
author avatar
Top 5LeaderboardReal User

The solution has legacy issues when it comes to compatibility. If you have older technology, you may run into compatibility problems with SQL. The solution is rather expensive.

2021-01-27T11:24:04Z
author avatar
Top 20Real User

The licensing costs are very high. I would like the scaling process to be more transparent and obvious. There's a lot of documentation on the web, and it is quite extensive, and yet it isn't very well organized which makes it hard to find items often.

2021-01-26T08:40:56Z
author avatar
Top 5LeaderboardReal User

There are a lot of improvements in the cloud space about which we open a case with Microsoft every now and then. These improvements are not in terms of features or functionality. They are more related to their own compatibility or connectivity on which they keep on working to improve the product.

2021-01-23T13:47:39Z
author avatar
Top 20Real User

Our customers are willing to pay less. For SQL server they have to buy it, they have to purchase the license. So, if we can get some free open source, like Firebird, InterBase, Firebase, or something like MySQL and also PostgreSQL, whichever one is suitable for us, we'd like to pick one. Additionally, in some cases it is quite difficult, like the lack of ease of the replication and other issues. They have to improve on that. They do not have features like "always on," which is complicated. One feature which we don't like is that they are providing CLR, and CLR can only be written in dot net, C sharp. But actually it should be open for all languages to write CLR so that we can hide our code. The next thing is that the tangent PSQ is encryptable but it is decryptable, as well. From the developer's point of view, all procedures are exposed.

2021-01-06T07:14:00Z
author avatar
Top 5LeaderboardReal User

If you have a lot of data and you want to perform computations on it, you will have problems and the performance will be degraded. There are problems when you are dealing with Big Data and it doesn't scale very well. For example, in Hadoop, you can partition your data very well, but in SQL Server, you can't do that. If it could handle horizontal scaling then that would be an improvement. We experience latency at times when there is a lot of data being processed. In Iran, there is a specific time when all of the markets are open, and a lot of people are using the data to make decisions. Performing actions at that specific time gives us a lot of problems because of limitations in SQL Server. The problem seems to be caused by writing a lot of data to the table at the same time. Improving the intelligence for managing the SQL server would be very good.

2020-12-30T13:34:32Z
author avatar
Top 20Real User

The solution could use better governance on the management side, especially around data governance. The product could do better at allowing for integrations.

2020-12-29T10:05:47Z
author avatar
Top 20Real User

Due to the fact that I'm dealing with the product more as a data analyst, the SQL Server management studio is really relatively primitive compared to other more advanced tools. There are other tools on the market that are much more advanced. It would be better if they managed to give us a bit more of a user-friendly product with just a bit more meat on the bone. It's a bit basic. There are a number of features that are lacking. Just recently I had to do something and it's not available on the SQL Server. However, it's available on another solution that's actually a much cheaper product. Some areas need improvement. For example, how you deal with the manipulation of data is probably not the best.

2020-12-28T10:53:51Z
author avatar
Top 5LeaderboardReal User

With any development language, any programming or software language available, there's always room for improvement. With SQL, it requires the more advanced integrated capabilities of Postgres, however, those capabilities do really come with obvious kinds of costs. For example, if SQL were to improve its functionality to incorporate the functionality that is in Postgres. Obviously, some kind of financial licensing will need to be incorporated. It's a bit of a catch-22 with a system similar to an SQL Server. If we want to avoid costs, we have to take a step back from certain integration capabilities. From a development perspective, the solution needs to be a lot easier to understand or it needs to be easier to implement API packages for connection pooling so we don't have connection interruptions when, let's say, a hundred people simultaneously access the network on a given system, utilizing a specific or single database. Any type of connection pool or connection integration that could increase the total number of users to access simultaneously would be beneficial. That said, I also know there are some security risks involved with that type of connection pooling. However, something from SQL-side that can increase its connection access or its connection stability for multiple user access to a single database system would be great.

2020-12-24T07:39:41Z
author avatar
Top 20Real User

Scalability is an area that needs improvement, and the deployment is difficult, which why I'm looking for an appliance to deploy it in a much more scalable way. I would like to know how you can scale to be a large enterprise server.

2020-12-09T17:43:34Z
author avatar
Top 20Real User

We would like to have a common storage option in the SQL Server. This option is available in Oracle Database. It would be great if Microsoft could create something like a columnstore that has not only indexing but also tables for common storage.

2020-12-08T18:22:46Z
author avatar
Top 5LeaderboardReal User

Overall, the solution could be improved in future releases. We hope to improve the way we use it ourselves in our next project. The solution could offer better integration with other solutions - specifically Microsoft.

2020-12-08T15:13:05Z
author avatar
Top 10Real User

Price could be cheaper, and access to reporting tools should be better.

2020-12-06T10:59:48Z
author avatar
Top 10Real User

The pricing could be improved. I would like to have the option to use fewer processors for certain tasks, thus reducing the licensing fee. That would be great.

2020-12-03T12:47:24Z
author avatar
Top 5LeaderboardReal User

I think a web console for the management studio, I think that would be a good thing. I think also on load balancing. I think that's something that we can use.

2020-11-30T11:06:00Z
author avatar
Top 20Real User

The time series database could be improved. There needs to be more storage space for large documents. The user interface and the reporting could also be improved. It's not bad, but it could be improved upon.

2020-10-28T19:12:04Z
author avatar
Top 20Real User

The performance needs some improvement and it needs more features integrated into it. Technical support could be better. Scalability could be less costly. One of the conflicts with Microsoft is if you have an enterprise relationship, you have to deal with a third-party offering Microsoft solutions. In the 2016 version, they don't have support for Python. It may be included with the 2019 version but if they don't, I would like to see support for Python implemented.

2020-09-03T07:49:44Z
author avatar
Top 5LeaderboardReal User

CAL licenses should cost less. Microsoft usually prices high for client access licenses. Server plus user client access license (CAL) licensing requires a separate Server license for each server on which the software is installed, plus a user CAL for each user accessing the server. A SQL Server CAL is required for a user to access or use the services or functionality of either edition of SQL Server and frequent updates to the latest versions will lead to obsolete and discontinuing the security patches has to be improved.

2020-08-06T12:29:00Z
author avatar
Top 5Real User

The scalability and the high availability feature can be expanded or improved. Currently, there is a limitation on scalability. A feature similar to the Oracle Diagnostic feature can be included to provide a better user experience.

2020-08-02T08:16:00Z
author avatar
Top 5LeaderboardReal User

The server itself doesn't need much improvement. The product overall would benefit from the addition of better tutorials to help master the skills necessary to actually build a project database. Right now, what is available isn't sufficient. Overall, I would suggest a nice tight integration with the toolset now known as Power BI. It might not even be missing, however, I'm planning to concentrate a lot of my time with the tutorials and I have Power BI loaded onto my HP laptop. bA brilliant student did it for me when she demoed it in a class. I'm going to use that copy of it and have many tutorials to get ready.

2020-07-26T08:18:59Z
author avatar
Top 20Real User

I'd like to see a simplification of the query optimizer and feel that SQL needs to look into the internal processing of the query because the query optimizer sometimes uses a different query plan, which we don't expect. It is similar to the triggers they have which are used after execution and not before. For example, if I'm running a query, my trigger will be run after the query has executed although I sometimes need the trigger before execution. That's a feature not supported by the product.

2020-07-22T08:17:25Z
author avatar
Top 5LeaderboardReal User

The number of concurrent users is too limited and other databases are better than SQL in this regard. There are limitations with load balancing. We would like to see support for in-memory processing.

2020-07-16T06:21:10Z
author avatar
Top 20Vendor

In terms of what could be improved, everything on-premises is now moving to the cloud. Obviously SQL Server has also moved because Microsoft has its own cloud called Azure SQL and azure synapse. Every solution comes with its own advantages and disadvantages. Each cloud has its own way to maintain resources and that plays a major role. But I would say that Azure Clouds are easy to work as compared to others. To Performance-wise it's still not as good as on-premises, but it is easy to work with. For example, if you are familiar with the SQL server then you don't need to put any effort to work on the Azure SQL or Azure Synapse. Your efficiency will not decrease and you can easily manage any projects. Its advantage is that it is very similar. Apart from that, if you moving to any other Warehouse like Snowflake, redshift with existing SQL server resources is a little difficult and organizations need to spend money on their training. Which increases cost.

2020-07-16T06:21:00Z
author avatar
Real User

Occasionally the performance, as good as it is, is a bit off. We sometimes experience memory spiking. If they could maybe fix that aspect of the solution, that would be quite helpful for our organization.

2020-06-15T07:33:50Z
author avatar
Top 20Real User

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

2020-04-19T07:40:00Z
author avatar
Top 10Real User

I would like to have more replication scenarios.

2019-09-22T17:46:00Z
author avatar
Real 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
Real 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
Real 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: July 2021.
522,946 professionals have used our research since 2012.