In addition to the order, you also have to worry about permissions. Do you have permissions to create the objects? Once created, do the objects have permissions to see other...

Depending on how you're defining transactions, you could go the Performance Monitor route, which just counts transactions, or you may need to set up a server side trace. You can...

One piece of advice. You're writing your queries using the ANSI 89 standard on joins. Don't do that. As soon as you get to outer joins you're going to have...

Man, I couldn't have been further off track. I totally missed several key words and tricky phrases in the original question. Sorry for any confusion tossed into the mix.

I wrote an article outlining several ways to get versioned data. Latest date is not any different than latest version. Take a look at this[/url] and post back here if...

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