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

Normally, my response is for the other party to...

OK. That's twice. It should stop now.

I'm so stupid...

This is 2005 right? Toss trace. Run a query against sys.dm_exec_query_stats. This is a dynamic management view that contains information about the queries currently in cache. You can...

Oops. There I am typing up the response and looking for your URL and there you are posting it. Ah well. Reinforces the point.