T-SQL

2 articles

Read as a book

Sql Server Oct 2, 2026 3 min read

SQL Performance Tuning: Estimating Percentage Improvements

When I’m doing performance tuning on an application in the early stages of its lifecycle (or any app that’s never had DBA attention before), I end up with a ton of recommendations within the first day of performance tuning. The resulting...

Saved by: Huy Vũ

Sql Server Sep 30, 2026 3 min read

If Your Trigger Uses UPDATE(), It's Probably Broken.

In yesterday’s blog post about using triggers to replace computed columns, a lively debate ensued in the comments. A reader posted a trigger that I should use, and I pointed out that their trigger had a bug – and then lots of users repli...

Saved by: Huy Vũ