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."The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"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."
"The product's initial setup phase was pretty straightforward, with no complex processes."
"The paramount advantage is the exceptional speed."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"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."
"From a security perspective, we have no complaints."
"The initial setup was straightforward."
"The product has been on the market for over 25 or 30 years. It's an extremely mature solution."
"It is a very user-friendly solution. It is easy to manage the databases and troubleshoot any issue. It is a perfect solution for the volume or transactions that we need to manage."
"What I like most is the management, as it is very easy compared with other products."
"The license fee is very low."
"Very stable relational database management system that offers ease of management, querying, and scaling. It has well-designed databases."
"If we want to expand to other servers and create an extra node, it's expandable."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."
"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."
"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."
"We don't get good discounts in Pakistan."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"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."
"SQL Server doesn't have proper bitmap indexing, proper columnar databases, or proper implementation of materialized views."
"They do not offer the SQL Server Management tool via the installation. It is a separate tool I use when I'm trying to configure the mirroring with SQL Server Mirroring. This is not supported and I'm getting some errors on the database mirroring."
"The maintenance and tasks should be improved so as to reduce database files."
"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."
"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."
"It's difficult to make changes. It's a very complicated product in general — that's the issue."
"The pricing and quality of the product could be improved."
SingleStore is ranked 6th 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 MySQL, Teradata, 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.