A document store added for one collection of variable-shaped supplier payloads, in an application whose other forty tables are relational. The migration back was two days and the…
A collection declared as time series is stored in a columnar bucketed format, which is a different physical layout for the same documents. The storage reduction is large…
Multi-document transactions arrived in June, and the interesting question is what their existence says about the schemas that wanted them. A document model that needs a transaction across…
A daily report scanning 1.2 million rows to return two hundred. Why neither obvious index helped, what the composite one costs, and the two answers I turned down.