News for hackers. Stuff that matters.
Re:Neeva Acquired by Snowflake by sv123 on Wednesday May 24, 2023 @09:25PM (#36066101)
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.
Re:Neeva Acquired by Snowflake by FridgeSeal on Wednesday May 24, 2023 @09:31PM (#36066138)
MSSQL 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.

Re:Neeva Acquired by Snowflake by berkle4455 on Wednesday May 24, 2023 @09:27PM (#36066114)
I don't think anyone disagrees with you. Clickhouse and Snowflake are both OLAP; neither are row-based (OLTP).
Re:Neeva Acquired by Snowflake by fuy on Thursday May 25, 2023 @08:43AM (#36070029)
There's columnar tables in SQL Server, though. Have you tried it? Would be interesting to compare to Snowflake.
Re:Neeva Acquired by Snowflake by FridgeSeal on Friday May 26, 2023 @05:03PM (#36089482)
As useful and powerful as the columnar tables in mssql are, they’re not on the same level as a full columnar db.