3 ms·
MSSQL currently does not have horizontal sharding capabilities like this, or easy UPSERT functionality.
by manigandham 8y ago
MSSQL currently does not have horizontal sharding capabilities like this, or easy UPSERT functionality.
- plasma 8y agoI've dabbled with SQL Data Warehouse (via Azure); wouldn't this be the horizontal functionality? It has some limitations, but curious how it compares to Citus.
- manigandham 8y agoYes but that's a different product designed with columnstores and still missing the upsert. This use-case was for lots of telemetry data that had high updates and very selective queries using indexes rather than large aggregations. Scale-out OLTP was better suited for these analytics than a normal OLAP system.
- plasma 8y agoThank you makes sense