I assume with the code formatting we'll be able to put a semi-colon in the code without having to sweat getting smiley faces:

SELECT * FROM (SELECT * FROM dbo.MyTable);

We've been using it pretty extensively for years. Yeah, it pretty much takes over as a development mechanism on your databases. However, it doesn't replace SSMS. There's still stuff that...

Given my druthers, I go with a singular object name, but I've long ago stopped worrying about some of the silly stuff. This is especially true when we have people...

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.