Browse by Tags

• clr
• performance
• query
• recursive
• sql
• SQL Server
• table
• trigger
• tsql

• Triggers within CLR - advantage over TSQL

  You may be aware the DML and DDL triggers can be nested up to 32 levels, because any reference to such trigger code counts as one-level in the nesting limit. Even though it is possible to control whether AFTER triggers can be nested through the nested Read More... Posted Tuesday, September 04, 2007 7:10 PM from SSQA.net | (Comments Off) Filed under: cte, SQL Server, performance, query, tsql, clr, table, trigger, recursive

• Set-based approach to finding consecutive records

  I'm sure I've written about this before, but it comes up so regularly in the newsgroups that I thought I'd write an answer here. A table (probably an audit table) exists with a field that stores a date signifying when a change was made. You need to return Read More... Posted Wednesday, January 17, 2007 10:15 AM from Rob Farley | (Comments Off) Filed under: sql, cte