Compare SQL Server vs. SingleStore DB
Quotes From Members
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
Pros | |
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short." | "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." "It is one of the most stable relational databases out there." "The most valuable feature is replication because we had several replicas of the SQL Server database in different geographical locations." "The availability is the most valuable feature. It has high availability. It also has good performance." "SQL is very easy to manage." "It helps with moving the design of the database into reality." "The feature that I have found most valuable is that it is easy to code." "Very good security features." |
Cons | |
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great." | "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." "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 would like to have more replication scenarios." "In terms of improvement, it could use more integration with other products." "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." "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." "In terms of what could be improved, everything on-premise is now moving to the cloud. Obviously SQL Server has also moved, because Microsoft Excel has its own cloud called Azure Finance. Every solution comes with its own advantages and disadvantages." "Query optimitzer could be simplified." |
Pricing and Cost Advice | |
"I would advise users to try the free 128GB version." | "It is expensive, but you get what you pay for." "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." "SQL Server is a cost-effective solution for a small database." "Pricing is reasonable for small organizations, but the scaling increases the price." "We didn't have any licensing costs for SQL Server." "We pay approximately $12,000 USD per month for both the server and the license." "The price could be cheaper." |
 Use our free recommendation engine to learn which Relational Databases solutions are best for your needs. 454,950 professionals have used our research since 2012. | |
Questions from the Community | |
Top Answer: SQreamDB is a GPU DB. It is not suitable for real-time oltp of course.
Cassandra is best suited for OLTP database use cases, when you need a scalable database (instead of SQL server, Postgres)… more » | Top Answer: The availability is the most valuable feature. It has high availability. It also has good performance. Top Answer: In terms of improvement, it could use more integration with other products. Top Answer: My primary use case is for data mining and processing data from plants. It's normally just for databases for the systems. |
Ranking  | |
Views 3,069 Comparisons 2,748 Reviews 1 Average Words per Review 1,087 Rating 10.0 | Views 23,252 Comparisons 19,444 Reviews 26 Average Words per Review 465 Rating 8.2 |
Popular Comparisons | |
 Compared 21% of the time.  Compared 14% of the time.  Compared 6% of the time.  Compared 6% of the time. Compared 5% of the time. | Compared 16% of the time. Compared 12% of the time.  Compared 11% of the time.  Compared 9% of the time. Compared 2% of the time. |
Also Known As | |
| Microsoft SQL Server, MSSQL, MS SQL | |
Learn | |
| SingleStore Video Not Available | Microsoft |
Overview | |
MemSQL is The No Limits Database™, powering modern applications and analytical systems with a cloud-native, massively scalable architecture for maximum ingest and query performance with the highest concurrency. MemSQL envisions a world where every business can make decisions in real time and every experience is optimized through data. Global enterprises use the MemSQL distributed database to easily ingest, process, analyze, and act on data in order to thrive in today’s insight-driven economy. MemSQL is optimized to run on any public cloud or on-premises with commodity hardware. To learn more, visit our Product page - https://msql.co/2xUDAqL. To use MemSQL, get started with a free trial - https://msql.co/2NZOAy9. | SQL Server is the Microsoft-driven relational database management system. This system is used to store data as well as retrieve it when necessary; these functions can be supported by individual users or by multiple users within a larger network. The Microsoft SQL Server has warehousing options, quality and integration services, management tools that are simple to implement, as well as robust tools for development. Looking at the more technical end of things, Microsoft SQL Server uses query languages such as T-SQL and ANSI SQL. Disaster recovery is one of the product's most prominent features, in addition to in-memory performance, scalability, and corporate business intelligence capabilities. |
Offer | |
Learn more about SingleStore DB | Learn more about SQL Server |
Sample Customers | |
| Uber, Akamai, Dell EMC, Samsung, Comcast, Kellogg | 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. |
Top Industries | |
Computer Software Company26% Comms Service Provider17% Financial Services Firm13% Healthcare Company9% | Computer Software Company14% Financial Services Firm14% Transportation Company7% Manufacturing Company7% Computer Software Company30% Comms Service Provider19% Media Company7% Insurance Company5% |
Company Size | |
No Data Available | Small Business34% Midsize Enterprise25% Large Enterprise41% |
Find out what your peers are saying about Microsoft, Oracle, SAP and others in Relational Databases. Updated: December 2020.
454,950 professionals have used our research since 2012.
SingleStore DB is ranked 10th in Relational Databases with 1 review while SQL Server is ranked 1st in Relational Databases with 26 reviews. SingleStore DB is rated 10.0, while SQL Server is rated 8.2. The top reviewer of SingleStore DB writes "MySQL Big Brother with built-in data pipeline, high concurrency, and blazing fast analytical queries". On the other hand, the top reviewer of SQL Server writes "Easy to use, can be used for free, and has great scalability". SingleStore DB is most compared with CockroachDB, MySQL, MongoDB, SAP HANA and Oracle Database In-Memory, whereas SQL Server is most compared with SAP HANA, Oracle Database, Teradata, IBM Db2 Database and SAP SQL Anywhere.
See our list of best Relational Databases vendors.
We monitor all Relational Databases reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.