CDC should perform far better than hand-written triggers on all those tables.

Make sure you have sufficient pre-allocated log space to hold the changes until CDC can process them all.

It's testing to make sure that @Num contains only "0"-"9"s and/or "-"s.

Jeff Moden (5/12/2014)

---

ScottPletcher (5/9/2014)

---

I don't understand the rationale...

I don't understand the rationale for that statement....

Sean Lange (5/9/2014)

---

scotsditch (5/8/2014)

---

I'm trying to do something so simple, it's driving me nuts. Especially since I remember doing it before.

I want to create a computed Column in a...

You can use a GLOBAL cursor and use dynamic SQL just to declare the cursor. You can process it in static code, including deallocating the cursor at the end.

T-SQL and SQL certainly are different. I, therefore, would never assume someone knew TSQL just because they wrote SQL on a resume.

TSQL to me would mean the person understood...

By default, yes, they will be stored in the same page.

Someone can, however, override SQL's default behavior, table by table, via "EXEC sp_tableoption" and force SQL to store all LOBs...

rwitt 95744 (5/7/2014)

---

I think placing this in my test data script will resolve the issue (or rather, cover it, for both situations):

DECLARE @DELETEDFROM_<tablename> bit = 1

IF (SELECT IDENT_CURRENT('<tablename>') = 1...

Jeff Moden (5/6/2014)

---

In that case, here we go… let’s test the “Original” code, Scott’s code, and my humble submittal. With any luck at all, someone will...

I use CONTEXT_INFO() to control triggers in those cases. If you disable the trigger, of course other deletes also won't process the trigger, when you might have wanted them...

No, don't think any other settings affect that.

Is there maybe something in the process where that table is truncating rather than deleting? Perhaps a missing foreign key constraint causing...

No reason for the overhead of reading a table just for that. Or to calculate, say, the first Tuesday or last Friday, etc., of a month. Calendar tables...

I would never use a table variable for this -- if something goes wrong after the DELETEs, but before the output has been processed, the data is gone, with no...

I suggest making your code as self-documenting as possible; then you need fewer additional comments. Naturally that means avoiding variable "names" like "E", "N" and so on. Example...