How often do you update the statistics on these two databases. I'll be they're out of sync. Also, do you do a regular re-index or index defrag? I'll bet there...

That drops linked servers on a local machine. That's not going to help with Express is it?

You're talking to the wrong guy. I'm posting this for our tech support guys. Luckily, I don't have to muck about in Express (yet). I'll try it out & get...

It's just up one more level

SELECT *

FROM OPENXML (@idoc, '/ROOT/Customer/Order/OrderDetail',2)

WITH (OrderID int '../@OrderID',

CustomerID varchar(10) '../@CustomerID',

OrderDate datetime '../@OrderDate',

ProdID int '@ProductID',

Qty int '@Quantity',

ContactName nvarchar(50) '../../@ContactName')

[beating head against desk] must read complete post, must read complete post...

Anyway, Jeff's 100% accurate. I didn't see that "must be stored" statement. You can't, don't, won't, shouldn't store the...

I agree with Colin, Sven and the GURU on this. Tuning is not simply a matter of running the DTA and taking its advice as gospel. Unfortunately, if you get...

SQL Server can take the last two formats you supplied and automagically convert them into date time, no issues. The first string you supplied, the more European approach of day/month/year,...

I think there's a way to see the query run by the report, but I can't find it right now. The fallback position it to put profiler on and then...

You really should have a clustered index, but since you get only one, you need to make sure you put it in the right place. The PK is clustered by...

One thing we've found that is a great advantage in 2005 when working with different functionality within a single app, is to take advantage of schemas. In your case, you...

I've done exactly that type of installation.

Yes, it causes problems. The 2008 install does something to the 2005 install that causes errors when you go to load the GUI for...

Yelling (all caps) is hardly necessary.

This link is to the general "How To" topic in Books Online.

This link is to the RESTORE topic in BOL.

Yelling at the people trying to...

I agree with Andy. I need the request written down in some fashion. If there is a policy in place and this violates it, I'm going to fall back on...

Honestly, contact Microsoft because your licensing scheme is not going to be the same as mine. We have an enterprise license for TFS that allows us pretty much unlimited use,...

The order by is a serious puzzler. If the performance was OK, I'd probably ignore it with a shrug, but if performance was in any way an issue, it sure...