Hundreds or even thousands per second isn't a lot really and if you are having timeouts I might say your existing hardware/structures are incorrectly spec'd. If you expect that...

no problem..

CEWII

Sean,

I think you have part of that wrong, table variable scrope from BOL is "A table variable behaves like a local variable. It has a well-defined scope. This is the...

check to make sure there are appropriate spaces and I'm not sure if SSIS is case sensitive in this case but I'm going to go down that path and the...

I'm assuming SSIS step..

You might look at adding a space:

];1 /CHECKPOINTING

CEWII

Well I admit I'm stumped.. Sorry..

CEWII

Great, thanks..

CEWII

Well if I misread context or meaning then I apologize. I was using the definition akin to dynamic SQL..

CEWII

These templates were created for SQL 2000, I am working on an updated set for...

Lowell (9/22/2011)

---

Elliot that is a really nice project, and...

If you chose to use the code from codeplex and have any trouble let me know, I am the author.

CEWII

Table splits (off the top of my head) really only occur for two reasons.

1. A record on the page is modified and the space required to store that row changes...

Lynn Pettis (9/22/2011)

---

Also in Books Online read about Service Broker. This would eliminate the need the need for a scheduled job and still have the processing of emails completed...

chandleya (9/22/2011)

---

I (re)wrote their data migration package to an extent - I took out all of their index operations and perform them as before & after steps in an Agent...

THe new rows added frequently kind of bothers me. Do you really want to send emails for each row? How do you want to do that? From...