Chris Lane (2/18/2009)

---

Yes, that is exactly what I need, but what to call the Question to group join table?

Question

QuestionID PK

QuestionGroup Or Just Group? Group by itself seems to vague.

QuestionGroupID...

So, we have a Survey, a Question, and a Group? What's the Group do and how does it relate to both Question & Survey? It really depends on how the...

And are you still seeing parallelism in the execution plan?

There has to be something going on, something different. If you simply air drop a database...

just as an experiment, try using a query hint on the query itself to set the max degree of parallelism to 1, just to see. Use: OPTION (MAXDOP 1)

I would. Is the old server a single CPU machine?

The parallelism settings are a SQL Server level setting, not on the database. You'll need to look there.

Hardware always matters. If your database is really tiny, memory might not...

distant star (2/18/2009)

---

Hello,

I am working on an automation script using detach-attach method for which I need help of you colleagues.

Following is the plan which has to be executed using a...

skt5000 (2/18/2009)

---

I have checked the settings and the only diff I see is that the new db is set at

nameminimummaximumconfig_valuerun_value

max text repl size (B)0214748364721474836472147483647

and the old is set at 65536....

Are the parameters the same for each execution?

Yeah, sorry, guess I should have said that too. There's nothing wrong with Express. It allows for less memory and fewer CPU's, but it will use the memory & cpu...

Or you could spend a trivial amount of cash & pick up Red Gate's SQL Compare. It's a fantastic tool.

Don't use a cursor. They're notoriously slow.

For more specific answers, I'd need to see the query & structure.

I'm not entirely sure I understand the problem. From the sounds of it, you think the compile doesn't affect CPU. It does.

If you can, can you post the query, an...

I'd be focused pretty much on the hardware and configuration issues. I remember the time we were troubleshooting a production performance problem. I backed up the database, moved it to...

I think if you go over to Red Gate you can still get a copy of my book on execution plans for free. You'll have to poke around. I don't...