DDL triggers fire when someone changes the schema. How to write one, what EVENTDATA gives you, and how to get back in if one locks you out.
SQL SERVER – Stored Procedure to display code (text) of Stored Procedure, Trigger, View or Object
Need to display code of a stored procedure, trigger, view or function? The system stored procedure sp_helptext prints the text of any unencrypted object.
SQL SERVER – Disadvantages (Problems) of Triggers
Triggers or stored procedures? The disadvantages (problems) of triggers I shared with my team: hard to see, hard to debug, and they can slow things down.
SQL SERVER – 2005 Understanding Trigger Recursion and Nesting with examples
How trigger recursion and nesting work in SQL Server 2005: triggers nest up to 32 levels, recursive triggers fire themselves, and both can be turned off.
SQL SERVER – Good, Better and Best Programming Techniques
My notes for a programmers meeting on Good, Better and Best Programming Techniques in SQL Server, plus a funny bug ticket about a client who got no email.
SQL Server Interview Questions and Answers Part 6
Interview Questions and Answers Part 6 covers the six properties of relational tables and de-normalization, adding redundant data to help performance.
SQL Server Interview Questions and Answers Part 4
Interview Questions and Answers Part 4 begins with SQL Profiler: what it is, how it captures events to a file or table, and how to keep traces small.