#backend - Tuned Instance

Skip to main content

Command Palette

Search for a command to run...

#backend

Articles tagged with #backend

UNION vs. UNION ALL: How Hidden Sort Operators Slow Down Your Combined Datasets
Unmasking the duplicate check penalty: Why combining queries can trigger unexpected disk grinding, how to trace performance plan warnings, and when to drop the distinct filter safely.
Jul 2, 20267 min read
Hidden CPU Burn: How Scalar User-Defined Functions Trap Your Queries in RBAR Loops
Unwrapping row-by-row bottlenecks: Why modular code kills database performance, how to track hidden UDF execution penalties, and how to convert functions into high-speed inline expressions.
Jul 1, 20266 min read9
The Local Variable Trick: How to Stabilize Stored Procedures and Bypass Parameter Sniffing
Tuning execution plans at the code level: Why hiding parameter values from the query optimizer stops performance spikes and creates rock-solid query consistency.
Jun 30, 20267 min read2
The Identity Crisis: How to Fix Arithmetic Overflow Error 8115 and Prevent Database Crashes
Defusing the 2-billion-row time bomb: Why auto-incrementing integer keys suddenly hit an invisible ceiling, how to audit your system limits, and how to migrate to BIGINT safely.
Jun 30, 20267 min read5
SQL Server Deadlocks: How to Track Down Error 1205 and Stop Query Collisions
Breaking the ultimate database gridlock: Why transactions violently collide, how to extract hidden XML deadlock graphs, and how to rewrite code patterns to eliminate victim states.
Jun 27, 20267 min read4
Mass Data Imports: How to Stop Transaction Log Bloat During Bulk Inserts
Unclogging the ETL pipeline: Why inserting millions of rows crashes your drive storage, how to unlock minimal logging, and how to load datasets at hardware line speeds.
Jun 27, 20267 min read42

© 2026 Tuned Instance

Archive
Privacy
Terms