We performed a comparison between SingleStore and SQL Server based on real PeerSpot user reviews.
Find out what your peers are saying about Amazon Web Services (AWS), Microsoft, MongoDB and others in Database as a Service."MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"The paramount advantage is the exceptional speed."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"It's a distributed relational database, so it does not have a single server, it has multiple servers. Its architecture itself is fast because it has multiple nodes to distribute the workload and process large amounts of data."
"Features like autoscaling, business continuity, and security are beneficial. The tool's compatibility with almost all of the enterprise-class applications is also beneficial for users."
"SSAS is the most interesting feature to organize the data and let the users play with it."
"SQL Server has good performance. It is one of the best features."
"For my business requirements, the performance is good."
"The scalability is very good."
"The product can scale if a company needs it to."
"I have found the most valuable features to be the flexibility and the vast amount of features available."
"As a data warehouse and storage solution, it's quite good."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"We don't get good discounts in Pakistan."
"For new customers, it's very tough to start. Their documentation isn't organized, and there's no online training available. SingleStore is working on it, but that's a major drawback."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"Their support could be better. There should be more visibility on the progress of the ticket, and their last line of support should be more knowledgeable. Other than that, we have nothing to complain about."
"Performance could be improved."
"The tool needs to improve its pricing and technical support."
"Support could be improved."
"The solution is expensive. The licensing costs are high."
"Other than Synapse and the other version of SQL Server, they face some problems while processing the data."
"The interface integration could be better."
"It pesters you to update the Client every month when there is nothing new that you really need to add, but it is constantly pestering you. I do not care for it."
SingleStore is ranked 7th in Database as a Service with 7 reviews while SQL Server is ranked 1st in Relational Databases Tools with 260 reviews. SingleStore is rated 8.8, while SQL Server is rated 8.4. The top reviewer of SingleStore writes "A reasonably priced product that offers good speed and seamless support". On the other hand, the top reviewer of SQL Server writes "Easy to use and provides good speed and data recovery". SingleStore is most compared with Teradata, MySQL, CockroachDB, Oracle Database and Vertica, whereas SQL Server is most compared with MariaDB, SAP HANA, Oracle Database, LocalDB 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.