It's almost 10pm, and there are still people blowing those things nearby. OK, I do live just off a fairly major road, but still, enough already.

Here's some...

Am I missing something here? http://www.sqlservercentral.com/Forums/Topic934829-146-1.aspx

Populate the parent table first?

I assume, by putting a foreign key in place, you don't want any values in the one table that aren't in the other. Therefore, you need...

No. Why would you want to do that?

What error are you...

As a guess, there's data existing in the tables that violates the constraint you're trying to add.

Yes.

Personally I lurk on forums, write blog posts and articles and present because I enjoy it, not because I'm paying dues or trying for an award. I'd be doing it...

I'd suggest start with Profiler. Find long-running queries and see if you can tune them. These may help.

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Depends on the size and usage of the databases. SANs aren't magic solutions to storage problems, and they're not exactly cheap.

Fortunately I was in...

Locked, barred, bolted and chained. As always.

I'm more concerned about the madness on the roads than at home. Especially since I'm onsite with a...

Madness began at midday today.

Grant Fritchey (6/9/2010)

---

At the point of a delete or insert, you do have access to the deleted & inserted temporary tables that will allow you to see what was deleted...

You may as well make that one partition. You're gaining...

Or you could use a virtual environment, like Virtualbox, to have a separate environment with SQL 2005.

Correct.

But what if I initially create it one 2005 and then use it one 2008. Will it automatically...