No. The instance-wide MAXDOP setting sets...

No worries. Ignore Joe's post if you can - and keep learning! 🙂

Sorry....

The 'cost threshold for parallelism' setting applies to the whole SQL Server instance.

The query optimiser will only consider looking for parallel plan alternatives if the best serial plan it finds...

jvanderberg (7/22/2010)

---

Server 2003 x64 and SQL Server 2005 should be able to use all those cores just fine. I think you will benefit more from the parallel processing of...

jcrawf02 (7/23/2010)

---

If you have to use schemabinding for a materialized view, and the view has to have a clustered index, when you create an indexed view you're essentially creating another...

That concatenation trick is only supported for backward-compatibility reasons.

It was never a good practice, and it remains slow and error-prone as you have discovered.

There is also no guarantee that it...

dma-669038 (8/10/2010)

---

I have a server on sql server 2005 sp3 running a query/stored procedure intensive application. They complained of slow performance and one of my fellow DBAs did a DBCC...

Hey Bhuvnesh,

My advice, generally, would be to omit the ORDER BY clause completely. The main reasons to include it are (a) to enforce the order of IDENTITY assignment in...

Probably not. My experience is that most DBAs, even if they have heard...

You bought Joe Celko's book?

Yes I remember that one (without looking it up). Very sneaky and...

Jack Corbett (8/5/2010)

---

I was just thinking the same thing. I haven't had a truly technical post in a quite...

:laugh: :laugh: :laugh: :laugh: :laugh:

Isn't associative memory wonderful?

Stick or branch join...bushy plans...funny!

Paul

Chris Morris-439714 (8/5/2010)

---

A few weeks back Paul W cleared a smokescreen with a definition of a type of join, something like a 'stick' or 'branch' join, where the ON predicates...