Practical articles about ClickHouse, SQL Server, analytics architecture, performance, migration, and database operations.
Build ordered text lists without accidental duplicates, missing-value surprises, or length limits, and know when structured JSON is the better output.
Read articleMany performance incidents disappear before an engineer captures the plan. Query Store preserves query, plan, runtime, and wait history for later analysis.
Read articleDistinguish intent locks from blocking table locks, measure the real lock footprint, and design batches that release locks between commits.
Read articleSend typed row sets to SQL Server without comma parsing, define validation and duplicate rules, and account for missing statistics and client binding.
Read articleDesign covering SQL Server indexes from real query predicates and ordering, then assess lookup savings against storage and write amplification.
Read articleUnderstand why a SQL Server temporary table is visible inside a dynamic batch but disappears when created there, and choose a clear ownership boundary.
Read articleUnderstand dirty reads with a two-session experiment, why NOLOCK still blocks, and how to replace it without breaking reporting correctness.
Read articleUnderstand rollback and caching gaps, retrieve generated keys correctly, monitor exhaustion, and separate technical identifiers from business numbering.
Read articleRebuilding every index on a fixed schedule consumes CPU, I/O, log space, and maintenance time even when users receive no measurable benefit.
Read article