First Itzik + Tom Moreau "Advanced Transact SQL" taught me ***a lot*** of tricks!

AWESOME!

RBarryYoung (3/23/2009)

---

GSquared (3/23/2009)

---

On the completely non-sequitur side of things, thanks to your post, I now have the song, "Row, row, row your code, slowly...

Outsourcing is a too wide term.

- Multiple cascade path are simply NOT allowed if you want to use CASCADE actions.

- You must either have a delete/archive script or break the cycle (changing the design).

This last part is pretty important 🙂

You may want to update also the Rights for INSTANT FILE INITIALIZATION now that you are at it 😉

I don't think is possible to run that sp on standby mode.

Noel, that's true. However, snapshot replication is much more forgiving. By dropping the article (i.e., table) out of the replication, you can then modify the keys. In this case, in...

Table partitioning comes in handy for these cases too. Keep it in mind in case you have EE 😉

I would start by identifying poorly performing queries and missing indexes before jumping into the scale-out train 😉

A job can only be started if it is not already running you should check the job status first or you will get an error.

Just one more note. Adding replication to your primary server does not come free. There is always a price to pay 😉

steve smith (3/20/2009)

---

Merge and Transactional Replication prevent the TRUNC command from working (I forget the specific error messages).

Are there any other SQL (or DBCC) commands that cannot execute...

Are you sure you "need" it?