IT Central Station is now PeerSpot: Here's why

SQL Server vs SingleStore comparison

Cancel
You must select at least 2 products to compare!
SingleStore Logo
3,198 views|2,247 comparisons
Microsoft Logo
21,417 views|16,448 comparisons
Featured Review
Buyer's Guide
Database as a Service
July 2022
Find out what your peers are saying about Microsoft, Amazon, Google and others in Database as a Service. Updated: July 2022.
622,949 professionals have used our research since 2012.
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."

More SingleStore Pros →

"The most valuable aspect of the solution is that it's integrated with the Visual Studio and also with Microsoft SQL Server Management Studio. It's a tool they have and it's quite easy to use and understand. It's the interface for programming for SQL Services.""The solution can be used for a host of applications.""I have found that SQL Server works very well in the Microsoft Dynamics environment.""SQL Server is very good, it can be used as a transactional database and used to support the data warehouse. Additionally, the ANSI-compliant satisfies our database properties.""Stability and usability, which is quite simple, are two of the solution's most valuable features.""The most valuable features are ease of use and the integration with Single Sign On (SSO), as well as with other Microsoft products.""We've found it to basically be pretty problem-free.""I love SQL Server's Common Table Expression. In addition to that, I like its lead and lag functions. That helped us reduce a lot of code when comparing rows in SQL Server."

More SQL Server Pros →

Cons
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."

More SingleStore Cons →

"We experience latency at times when there is a lot of data being processed.""I would like to have the option to use fewer processors for certain tasks, thus reducing the licensing fee.""The Management Studio is a pretty heavy piece of software, and it's sometimes slow. I would recommend making an express version of the Management Studio, which is lighter and has fewer features but is a little faster.""The user interface and the reporting could also be improved.""The free version of SQL Server is time-limited before updating to the paid version.""The solution needs to be more secure. It's lacking, compared to, for example, Oracle.""The integration could be better. They are not open-source, so the integration with other platforms is not that easy.""Performance could be better. But I don't know if it's a problem with my application or with my database."

More SQL Server Cons →

Pricing and Cost Advice
  • "I would advise users to try the free 128GB version."
  • More SingleStore Pricing and Cost Advice →

  • "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."
  • "Cost is a major derivative for any organization. It has a reasonable cost value, and its cloud support is also better than others. Comparatively, Oracle can do the same things or is even better in certain areas, but it is expensive. The cost along with the support are the plus factors for SQL Server."
  • "We have had to purchase the Enterprise version to the tune of a few hundred thousand dollars, which is just ridiculous."
  • "With recent releases, the Standard Edition (cheaper) SKU has some of the earlier version Enterprise features. SQL Express has some limitations."
  • "The cost is high and because it's an expensive product, we are in the process of moving towards open-source solutions."
  • More SQL Server Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Database as a Service solutions are best for your needs.
    622,949 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short.
    Top Answer:I would advise users to try the free 128GB version. MemSQL also comes with "Cluster-in-a-box", which allows you to run it on a single instance. This is a great way to save money and get your hands… more »
    Top Answer:There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great. MySQL to MemSQL replication would be great. If it could replicate from MySQL… more »
    Top Answer:We're satisfied with the stability.
    Top Answer:Performance-wise, SQL cannot handle large amounts of data. In the next release, I would like them to commission SQL Server on Linux, as has been announced in the past but has not yet happened.
    Ranking
    6th
    Views
    3,198
    Comparisons
    2,247
    Reviews
    1
    Average Words per Review
    1,087
    Rating
    10.0
    Views
    21,417
    Comparisons
    16,448
    Reviews
    168
    Average Words per Review
    444
    Rating
    8.2
    Comparisons
    Also Known As
    Microsoft SQL Server, MSSQL, MS SQL
    Learn More
    Overview

    Lenses is a simple and secure self service DataOps platform, to operate with confidence on Apache Kafka & Kubernetes.

    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
    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
    VISITORS READING REVIEWS
    Computer Software Company24%
    Comms Service Provider17%
    Financial Services Firm15%
    Manufacturing Company6%
    REVIEWERS
    Financial Services Firm19%
    Computer Software Company12%
    Manufacturing Company10%
    Government5%
    VISITORS READING REVIEWS
    Comms Service Provider23%
    Computer Software Company20%
    Financial Services Firm8%
    Government5%
    Company Size
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise14%
    Large Enterprise69%
    REVIEWERS
    Small Business43%
    Midsize Enterprise20%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise16%
    Large Enterprise63%
    Buyer's Guide
    Database as a Service
    July 2022
    Find out what your peers are saying about Microsoft, Amazon, Google and others in Database as a Service. Updated: July 2022.
    622,949 professionals have used our research since 2012.

    SingleStore is ranked 6th in Database as a Service with 1 review while SQL Server is ranked 1st in Relational Databases Tools with 167 reviews. SingleStore is rated 10.0, while SQL Server is rated 8.2. The top reviewer of SingleStore 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 "Good performance, well-priced, trivial to set up, and helpful support". SingleStore is most compared with MySQL, CockroachDB, Cloudera Distribution for Hadoop, Oracle Database and Teradata, whereas SQL Server is most compared with SAP HANA, Oracle Database, LocalDB, MariaDB and IBM Db2 Database.

    We monitor all Database as a Service 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.