Compare ClickHouse and Microsoft SQL Server 
Featured Products
At a Glance
Market Segments
Small-Business (50.0% of reviews)
Enterprise (45.5% of reviews)
Entry-Level Pricing
Starting at $1.00 Per Month
No pricing available
ClickHouse
Star Rating
(21)4.4 out of 5
Market Segments
Small-Business (50.0% of reviews)
Pros & Cons
Entry-Level Pricing
Starting at $1.00 Per Month
Learn more about ClickHouseMicrosoft SQL Server
Star Rating
(2,261)4.4 out of 5
Market Segments
Enterprise (45.5% of reviews)
Pros & Cons
Entry-Level Pricing
No pricing available
Learn more about Microsoft SQL ServerSummary
AI Generated Summary
AI-generated. Powered by real user reviews.
- G2 reviewers report that Microsoft SQL Server excels in user satisfaction, with many praising its 'Always On' feature that enhances database durability and application performance. Users appreciate the straightforward implementation process and the intuitive interface, making it accessible even for beginners.
- Users say ClickHouse stands out for its exceptional query performance, particularly on large datasets. Reviewers highlight its columnar storage design that optimizes both storage and computation, making it ideal for real-time analytics workloads.
- According to verified reviews, Microsoft SQL Server is recognized for its strong integration capabilities with other Microsoft tools, which enhances its usability in enterprise environments. Users mention the powerful features for managing and analyzing data as significant advantages.
- Reviewers mention that ClickHouse is incredibly fast, often described as the fastest database available, capable of querying millions of rows in just seconds. This speed is a major draw for users focused on performance and efficiency.
- G2 reviewers highlight that while Microsoft SQL Server has a robust support system, ClickHouse users appreciate its quality of support, noting a higher satisfaction score in this area. This indicates that ClickHouse may offer more responsive assistance for its users.
- Users report that Microsoft SQL Server has a higher overall rating in terms of reliability and performance, but ClickHouse's innovative features and cost-effectiveness make it a compelling choice for small businesses looking to optimize their analytics capabilities.
Pricing
Entry-Level Pricing
ClickHouse
ClickHouse Pricing
Starting at $1.00
Per Month
Options for every user, organization, and use case.
- Up to 1 TB storage
- 16 GiB total memory
- Burstable CPU
Microsoft SQL Server
No pricing availableFree Trial
ClickHouse
No trial information availableMicrosoft SQL Server
No trial information availableRatings
Meets Requirements
9.0
12
9.0
1,854
Ease of Use
8.8
12
8.6
1,870
Ease of Setup
9.2
8
8.1
992
Ease of Admin
7.0
5
8.3
950
Quality of Support
8.5
10
8.3
1,649
Has the product been a good partner in doing business?
Not enough data
8.4
900
Product Direction (% positive)
10.0
11
8.4
1,825
Features by Category
Management
9.4
6
8.9
153
7.9
7
8.8
153
9.3
7
9.2
158
9.4
6
8.9
153
10.0
5
8.9
156
Maintenance
8.8
7
8.9
154
7.8
6
9.0
159
Not enough data
9.0
154
Security
Not enough data
8.9
153
Not enough data
9.1
155
Management
Not enough data
9.0
149
9.3
5
9.2
151
Feature Not Available
8.8
137
Not enough data
8.8
142
Support
Not enough data
8.6
145
Not enough data
9.0
149
Not enough data
8.6
144
Not enough data
8.4
151
Security
Feature Not Available
8.8
148
Not enough data
9.0
148
Not enough data
8.8
145
Not enough data
9.0
149
Performance
Not enough data
8.7
144
Not enough data
8.8
141
Not enough data
8.7
147
Not enough data
8.6
145
Not enough data
8.8
146
Database Features
9.0
5
8.9
1287
9.3
5
9.0
1291
9.0
5
8.9
1299
9.0
5
8.7
1266
Not enough data
8.8
1267
Not enough data
8.8
1271
8.7
5
9.1
1291
Storage
9.2
6
Not enough data
9.0
7
Not enough data
Availability
Feature Not Available
Not enough data
7.8
6
Not enough data
8.3
6
Not enough data
Performance
8.1
6
Not enough data
Security
9.0
5
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
8.3
5
Not enough data
Support
Not enough data
Not enough data
Not enough data
Not enough data
Query latency
Not enough data
Not enough data
Not enough data
Not enough data
Data latency
Not enough data
Not enough data
Not enough data
Not enough data
Connectors
Not enough data
Not enough data
Not enough data
Not enough data
Scale
Not enough data
Not enough data
Not enough data
Not enough data
Architecture
Not enough data
Not enough data
Not enough data
Not enough data
Database
Not enough data
8.5
56
Not enough data
8.8
57
Not enough data
8.4
54
Integrations
Not enough data
7.8
45
Not enough data
8.2
45
Platform
Not enough data
8.2
50
Not enough data
8.5
53
Not enough data
8.2
45
Processing
Not enough data
8.5
52
Not enough data
8.5
55
Building Reports
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Platform
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Not enough data
Categories
Categories
Shared Categories
ClickHouse and Microsoft SQL Server are categorized as Database Management Systems (DBMS) and Relational Databases
Unique Categories
ClickHouse is categorized as Real-time Analytic Database and Columnar Databases
Microsoft SQL Server is categorized as Big Data Processing and Distribution and On-Premise Data Integration
Reviews
Reviewers' Company Size
ClickHouse
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Microsoft SQL Server
Small-Business(50 or fewer emp.)
Mid-Market(51-1000 emp.)
Enterprise(> 1000 emp.)
Small-Business
(50 or fewer emp.)
Mid-Market
(51-1000 emp.)
Enterprise
(> 1000 emp.)
Reviewers' Industry
Information Technology and Services
35.0%
Computer Software
20.0%
Wholesale
5.0%
Telecommunications
5.0%
Marketing and Advertising
5.0%
Other
30.0%
Information Technology and Services
24.1%
Computer Software
13.7%
Hospital & Health Care
5.4%
Financial Services
4.3%
Higher Education
2.9%
Other
49.6%
Alternatives
Discussions
ClickHouse has no discussions with answers
How could I make much easier the experience with the order of my database?
4 Comments
AF
You can create different tables with your employee information eg employee table, employee roles etc. Then you can create a single view that will pull data...Read more
What is the best way to save your queries?
4 Comments
CA
I recommend that you use the saved querys in plain text or .sql or txt format you can use the same sql server query creator or a notepad +++ tool, they are...Read more
How can I work on the same query if the connection is lost (timeout) and then I reconnect?
4 Comments
JE
When this happens to me in SQL Server Management Studio, I just have to type USE {your database name here} and then select only that statement and execute...Read more
Hunting for software insights?
With over 3 million reviews, we can provide the specific details that help you make an informed software buying decision for your business. Finding the right product is important, let us help.
