Developer news without the noise — My Dev News in Telegram.

Open botLearn more
Stuzhuk Lab

Stuzhuk Lab — Chemistry of Code

Chemistry of Code

  • Home
  • Portfolio
  • Services
  • Blog
  • Contact
  • Sign in
  • 🇬🇧
    🇷🇺🇺🇦
← All posts

Tag

sql server

All blog posts with this tag.

  • 24 Oct 2026

    Optimizing Huge Databases: SQL, Indexes, Schema, and Architecture at Billions of Rows

    A practical reference for large databases: plan diagnostics, queries, indexes, EAV in ERP, partitions, locking, caching, and scaling for PostgreSQL, SQL Server, and MySQL, without the "just buy SSDs" myth.

    architectureBackenddatabaseerpmysqlPerformancepostgresqlsql server

We store small technical data in your browser (theme, typing progress, reading history) and cookies for language/session. Not ad tracking.