Library
150 results
Throttled at 30% usage? Throughput is split across physical partitions, so one hot partition key throttles alone. Diagnose it, then fix keys, RU costs and scaling.
#data-modeling#performance#troubleshooting
MongoDBAdvancedSeven ordered questions that decide embed, reference or a hybrid, the mechanical cost of each choice, and a help desk schema worked through end to end.
#data-modeling#nosql#schema-design
DuckDBIntermediateDuckDB can spill to disk, but memory_limit, temp_directory, insertion order and thread count decide whether it does. Settings and query patterns that prevent OOM errors.
#configuration#performance#troubleshooting
MongoDBIntermediateA catalogue of twelve MongoDB modeling patterns, each with a document shape, the query or update that uses it, and what it costs.
#data-modeling#nosql#schema-design
QdrantIntermediateFast until you add a filter? Create payload indexes before loading data so the filterable HNSW can use them, and set up multi-tenant collections the right way.
#indexing#performance#vector-search
MongoDBIntermediateHow to design a MongoDB schema from the workload, the hard limits that constrain it, and seven anti-patterns with a way to detect and fix each.
#data-modeling#nosql#performance
CockroachDBIntermediateSQLSTATE 40001 is how serializable isolation stays correct in a distributed database. Add client-side retries, cut contention, and know when READ COMMITTED fits.
#concurrency#transactions#troubleshooting
SQL ServerIntermediateA diagnostic catalogue of slow query causes in SQL Server: how to tell running from waiting, the plan or wait signature of each cause, and the fix.
#execution-plans#performance#troubleshooting
SnowflakeIntermediateYou pay for warehouse run time, not query work. Find where the credits go, fix auto-suspend and warehouse sizes, and add resource monitors before the next invoice.
#configuration#cost-optimization#performance
SQL ServerIntermediateA query-first method: find the expensive queries, read the plan for signs the missing index DMVs never report, build the index online safely, then verify and roll back.
#execution-plans#indexing#performance
Scan with a FilterExpression still reads and bills every item. Use GSIs, sparse indexes and composite sort keys instead, and know when to send queries elsewhere.
#data-modeling#indexing#nosql
