Which editor? As an FYI for me.

I loved Foxpro. First SQL App I wrote was an upgrade from Fox/DOS to VFP/SQL Server. Worked great!

It seems...

I have a bunch of DVDs and ThinkGeek stuff so far. Based on registrations, it looks like an iPad is a real possibility now.

Not yet, but we're working on it.

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...