3 ms·
We use both MS SQL and Snowflake heavily. There are clearly instances where having row based storage is appropriate, and also instances where columnar storage
by sv123 3y ago
We use both MS SQL and Snowflake heavily. There are clearly instances where having row based storage is appropriate, and also instances where columnar storage outperforms. All based on your workload and not just marketing.
- berkle4455 3y agoI don't think anyone disagrees with you. Clickhouse and Snowflake are both OLAP; neither are row-based (OLTP).
- FridgeSeal 3y agoMSSQL is an OLTP based db (going to preclude discussion of its fancy column index stuff it’s capable of). OLTP db’s definitely, definitely have a different role. I’m talking about the false difference between the likes of ClickHouse and Snowflake, where they’re both column oriented already. I’m asserting that the fundamental differences between “classic” column db’s and “data warehouses” is far less fundamental than the marketing would have us believe. Some of the db’s in this space have slightly different architectures and trade offs, and some deliberately operate at different scales, but they are built for, and operate in, basically the same purpose.
- fuy 3y agoThere's columnar tables in SQL Server, though. Have you tried it? Would be interesting to compare to Snowflake.
- FridgeSeal 3y agoAs useful and powerful as the columnar tables in mssql are, they’re not on the same level as a full columnar db.