I would say that Gus' suggestion of one big trigger allows you to see all the code, and perhaps optimize it. You might have a trigger designed for a certain...

Excellent

http://xkcd.com/810/

Each trigger adds to the transaction time since it is included in the transaction that is doing the update. That can impact performance as locks are held longer to complete...

David Stout (10/26/2010)

---

So much for early registration guess I'll be missing out on the fun. The code was not available when I registered.

PASS and use SSC2010 as the code.

Note that...

You don't quite have enough information. Is there not a key in the positions table? Is it allowed that there are multiple positions with a department? There's not enough sample...

Right now there's a legal challenge as to the rights of MERS to sign foreclosure documents, but there have been mistakes made, and someone is challenging the accuracy of data...

Indeed, that's a tough one. I've dealt with those migrations. that is a case where you wish you had GUIDs

The copy will no degragment the file. It might move the various segments on disk around, but it will not move the internal allocations.

You need to rebuild clustered indexes to...

I think that we'll get back globally at some point. Maybe not the same point for all countries, but the economies will rebound for most places.

I've seen and heard doom...

If you want to delete the old backup first because of space constraints, make sure you have it on another server. Because your server will choose to fail right between...

I watched the last 4 innings Sat night of the Giants/Phillies game. Fantastic ending. Can't believe that Howard didn't swing. He'll be thinking about that for a long, long time.

The agent can't log into other servers: no rights.

However, you can proxy a job with another account. http://msdn.microsoft.com/en-us/library/ms189064.aspx

I figure I can just fix the hunter's computer and let him get me a cow 🙂

I think it's more like "do it for...

Some people are definitely not sure about how to research something, or unwilling to try. Or they want a quick solution without work.