Did you try updating the statisitics with a FULL SCAN? They're pretty widely out of line. That's frequently an indication that they're out of date.

You're getting a loop join on...

I've never heard of anyone recovering a dropped database.

You usually can't recover from the OS because SQL Server database files are locked while SQL Server is running (and in most...

You can use the information from the missing indexes DMV as a starting point for tuning. You need to carefully assess the recommendations though because they're frequently weak. I've seen...

Sounds like you just want a JOIN. Read the article Gail suggested and post the code you've tried so far.

I agree with Gail, hardware is not the place to start, especially since it appears that you've got a pretty strong system. Have you systematically collected performance data on the...

Try Ross Mistry's book, SQL Server 2008 Management and Administration. It's pretty good. For just a "what's new" point of view, Rob Walters' Accelerated SQL SErver 2008.

Neither of these will...

Some of those views are deprecated in 2008. Get used to using DMV's for this type of data. Here's a script from Technet

select

t1.resource_type,

...

Oh, and run a consistency check before the migration and after the migration. Paranoia...

Just be utterly paranoid. Take a backup before the move. Take a new backup after the move from the new server. Keep both on the side for a few days,...

Well, the reason I'm suggesting you need to define the clustered index as a seperate step is because, it doesn't necessarily come from the primary key. Don't confuse the two...

Yeah, you're making sense, apparently I'm not.

I didn't mean that the child table would have those values, instead it has the FK to the PK of the parent, right?...

You might try changing the order of the table definitions. I know everyone says that doesn't make a difference, but what they mean is, it doesn't normally make a difference....

yeah, it shouldn't be an issue.

Let's assume your data looks something like this:

Columns in Table 1:

ParentID KeyVal1 KeyVal2 Some Data

Columns...

TheSQLGuru (7/16/2009)

---

"hints" is a very broad topic. Did the OPTION RECOMPILE get used widely and cause issues, or are you lumping that in with things like FORCE ORDER, INDEX...

zach_john (7/16/2009)

---

Is there a better way to write the query to the given table ?

SELECT Top 1 @ContainerUUID=ContainerUUID

from CM_VENDOR_CONTAINER(NOLOCK)

where IsNULL(VENDorContainername,'')=IsNULL(@VENDorContainerName,'')

And IsNULL(VENDorContainerID,'')=IsNULL(@VENDorContainerID,'')

And FileUUID=@FileUUID

CREATE TABLE [dbo].[CM_VENDOR_CONTAINER](

[ContainerUUID] [uniqueidentifier]...