Skip to content
Search Ctrl K
Articles

T-SQL

If Your Trigger Uses UPDATE(), It's Probably Broken.
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...

By Huy Vũ
Additional T-SQL Improvements in SQL Server 2022
Sql Server Sep 4, 2026 16 min read

Additional T-SQL Improvements in SQL Server 2022

Recently I covered some of the T-SQL improvements in SQL Server 2022 here, and Aaron Bertrand covered additional improvements here. Those improvements were introduced in CTP 2.0. Microsoft just announced the release of SQL Server 2022 CT...

By selectgo