Try our new research platform with insights from 80,000+ expert users

SQL Server vs kdb+ comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

kdb+
Ranking in Relational Databases Tools
25th
Average Rating
9.0
Number of Reviews
1
Ranking in other categories
No ranking in other categories
SQL Server
Ranking in Relational Databases Tools
1st
Average Rating
8.4
Reviews Sentiment
6.9
Number of Reviews
267
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of February 2025, in the Relational Databases Tools category, the mindshare of kdb+ is 0.3%, up from 0.2% compared to the previous year. The mindshare of SQL Server is 20.1%, down from 23.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Relational Databases Tools
 

Featured Reviews

Nitin Garg - PeerSpot reviewer
An easy-to-deploy solution that can be used for data ingestion and usage
I work for a fintech company where we create several strategies generally built on finance data, which are like one-time series data. We deal with huge bulk data on a daily basis, and we use kdb+ for data ingestion and usage The most valuable feature of kdb+ is the speed at which it returns the…
Azizul Haque - PeerSpot reviewer
It has eliminated all kinds of inconsistencies, and it is reliable, secure, and fast
I don't know whether SQL Server can support large organizations where the database size is more than 100 GB. It might be because of SQL Server, or it might be because of the programming of the software vendor, but a lot of people think that it is a problem with SQL Server. It can't handle a large amount of data or large data size. In terms of its usage, about 90% of our applications are running on the SQL Server database. We have around 1,600 users for our software, and all the applications are connected to the SQL Server database.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The solution returns data quickly, and data retrieval is fast in kdb+."
"I like the availability group functionality. We are setting up more clusters using availability groups. The enterprise licensing or Software Assurance makes it a little bit cheaper as well. It is nice to have that read-only copy for reporting and everything else."
"It's much more friendly in comparison with Oracle."
"The Azure SQL Server database requires almost zero maintenance and management."
"It helps with moving the design of the database into reality."
"Its speed and the ease of server management are valuable. If I compare Microsoft SQL Server to MySQL, what I like in Microsoft SQL Server is the speed. We are using Microsoft Management Studio for managing our Microsoft SQL Server, and the user interface that I get to work with is also better."
"The stability is fine, especially if you're hosting it on AWS or Azure. You can get up to 99.99% stability on AWS."
"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."
"I have contacted technical support, and overall my experience with technical support was okay."
 

Cons

"The solution should have a more user-friendly user interface."
"I do not think SQL Server is suited for a typical database warehouse environment. However, people do use SQL Server for data warehouse environments but the best use case is for very small databases. If somebody wants to store more than 10 TB of data querying then the performance really degrades. The performance should be improved in the future to allow more scalability."
"Analysis services have a lot of room for improvement. Basically, manageability on the available tools. They should have improved them already. They are not very efficient. My main headache is with the analysis service, and it would be really good if Microsoft developed some additional tools that are more user-friendly to manage the analysis. This is both from the perspective of management, users' roles, and performance analysis. My main wish for SQL Server would be that management tools for analysis services grow and mature a bit."
"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."
"Could have additional security."
"The treatment of database storage could be improved."
"I would like to see more integration with other products and it needs to be more secure."
"I would like Microsoft to evolve SQL Server because stateful databases dying are in a way. We would like to find out if it can absorb Hadoop and other similar things. They should make it useful for data mining. Data is evolving forever, and how we store it is also changing constantly. So, SQL Server also needs to change."
"The performance degrades when the data is huge."
 

Pricing and Cost Advice

Information not available
"This is a downside of enterprise Microsoft products."
"My advice is quite straightforward. If you know the number of users who really and truly need access to the Server then it is a no-brainer. If you do not know, then get the basic package and minimum licenses and start from there. Needless to say, users can develop/use data structures outside and then deploy onto the Server."
"Since we are a cloud-based company, there is AWS pricing on top of the SQL Server pricing. The Enterprise Edition can typically sell from around $1000 dollars a month, which is not cheap. Then, there is an additional one-time Windows cost, based on the code, which can go anywhere from $30,000 to $40,000 for the license."
"The product is expensive."
"It costs a lot."
"The product’s price depends on the specific server requirements."
"We are on a monthly subscription and the price could improve. However, the price has worked out well in some deployments. The problem is you never know what kind of services been installed and you have to be in touch with many people, such as which servers are active or which are not. I did face a couple of issues in terms of subscriptions and the pricing model. They have improved over time."
"There is an annual license and it is priced reasonably."
report
Use our free recommendation engine to learn which Relational Databases Tools solutions are best for your needs.
838,640 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
42%
Computer Software Company
12%
Real Estate/Law Firm
8%
Manufacturing Company
7%
Educational Organization
52%
Financial Services Firm
8%
Computer Software Company
6%
Manufacturing Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about kdb+?
The solution returns data quickly, and data retrieval is fast in kdb+.
What needs improvement with kdb+?
The solution should have a more user-friendly user interface.
What is your primary use case for kdb+?
I work for a fintech company where we create several strategies generally built on finance data, which are like one-time series data. We deal with huge bulk data on a daily basis, and we use kdb+ f...
Would you say the price of SQL Server is high compared to that of similar products?
SQL Server is fairly priced because it has various editions, depending on the number of users, servers, or core packs you are using. If you compare the product to others in this category, the price...
Has using SQL Server helped your organization in any way?
SQL Server has helped my organization through partitioning to distribute the workload, as it splits them up into smaller pieces so the machines can easily deal with it. However, this comes with a h...
Which authentication mode is best for SQL Server?
My company connects through SQL Server authentication. We have company Windows accounts, but we do not want to connect the two, out of security concerns and to keep things separated for our own pur...
 

Comparisons

 

Also Known As

No data available
Microsoft SQL Server, MSSQL, MS SQL
 

Overview

 

Sample Customers

UniCredit, AIRBUS
Microsoft SQL Server is used by businesses in every industry, including Great Western Bank, Aviva, the Volvo Car Corporation, BMW, Samsung, Principality Building Society, Wellmark Blue Cross and Blue Shield, and the Catholic District School Board of Eastern Ontario.
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases Tools. Updated: January 2025.
838,640 professionals have used our research since 2012.