Did you update all the statistics after the migration?

Generally, there are exceptions, I've found SQL Server 2005 to be a bit faster, after some adjustments. You may want to check...

You should just go through and update all the statistics, everywhere. Statistics are pretty different from 7 to 2000 and even more so from 2000 to 2005.

You'll want to...

Nothing really. The N is meant for use with string constants, the way you used it. The CAST is meant to work with just about any structural object that you...

Couldn't you ensure the distribution this way?

WHEN (DATEDIFF(DAY, [Date on Waiting List], GETDATE()) / 7) BETWEEN 4 AND 8

THEN 2

And why aren't you using WEEK (or ww or...

There's no real way to know this. If the same database you have in production was on a machine, all by itself, with no users, it might take 1 minute...

jaggity (10/16/2008)

---

I might be able to use that, but my issue is that the third party defines tharray with all members as (it appears) 81 characters. So if I...

Do the execution plans change between the two?

I agree with Matt. It's probably parameter sniffing.

The easiest way to do it is probably with a backup & restore.

However, if you're making lots of changes over time to the structure or the data, you may want...

jonathanmreynolds (10/16/2008)

---

Hi all - I have an ISQL Batch File here:

isql.exe -U SA -P XXXXXX -d DBNAME -S SERVERNAME -n -i vsm_his2he.sql -o log.txt

bcp DBNAME.dbo.hotel_expert_room_registry out out1.txt -f param.txt -S...

You can use a PRINT command to put it out into the Messages window.

If you do nothing else at all, I'd recommend bumping that up to something like 25 or 30. I've seen it set as high as 50 on servers that still...

Since you've got parallelism on, what's the threshold set to?

I'd suggest checking the variable that's being executed as the query, @clk_fund_stmt (and the others). Make sure that's structured correctly. If you're getting nulls, it's originating there.

There was also a presentation from one of the SQL Server internals guys at the PASS summit a couple of years back called "A Day In The Life of...

Go back and reread Gail's post. She shows you how to measure which procs are taking the longest & using up CPU. Once you identify the query or queries that...