You're performing either ANSI 89 style joins. Instead, you should use the ANSI 92 style

SELECT ...

FROM TABLEA AS a

JOIN TABLEB AS b

ON a.ID = b.ID

LEFT JOIN TABLEC AS c

ON b.NewID...

Marios Philippopoulos (6/10/2011)

---

I must admit I've always played around with the MAXDOP setting when I had high CXPACKET waits.

Grant's suggestion is something I had never considered before.

So, if I...

You're not using the right protocol or a protocol is not enabled on the server is my first thought? Or, maybe you've got the server name wrong? Maybe the name...

I know that we had lots of apps with issues, but I have to say, most of our servers were up at least 3-4 months at a time. They'd probably...

I'm not entirely sure I understand the problem as you defined it, but if I understand correctly, aren't we just talking about a series of queries with parameters? You pull...

Ah, well, since this is one of the DMOs that is only reset when the instance is restarted, I suspect it's not that vital.

LutzM (6/10/2011)

---

GilaMonster (6/10/2011)

---

I can call a horse a car, doesn't make it one. Incremental backups != transaction...

GilaMonster (6/10/2011)

---

Grant Fritchey (6/10/2011)

---

As to keeping logs, once you have differential backups in place, you only need logs back to the last differential. Recovery would go, Full Backup, Latest Differential...

If by incremental you mean all the changes since the last incremental and then all the changes since that one... nope, no such critter. You answer that question with Differentials...

I have not seen a differential backup cause any more pain in terms of CPU than a regular backup. I suppose it might add something to the load, but from...

First off, that article is 7 years old, so almost anything it says might be slightly off these days. However, I just read through it and frankly, the author is...

It's not actually a table. It's a Dynamic Management View. If you're looking for it in SSMS, you need to look in system views. But no, unless you've got a...

Probably no difference because starting the shut down process on the server is going to start the shut down process on SQL Server. But I would still do it by...

The decision for which queries to put through parallelism is all based on the cost threshold, so controlling than rather than simply turning off parallelism completely I've found to be...

To my knowledge it can't be, but these tables are all very small. If you have that much memory pressure, you should be looking at your processes, not attempting to...