I wouldn't mind some new power tools. Golf gear is nice too. But the best gift is my kids enjoying what they get.:cool:

Jeff Moden (12/22/2011)

---

Ninja's_RGR'us (12/22/2011)

---

Jeff Moden (12/21/2011)

---

Aspet Golestanian Namagerdi (12/21/2011)

---

Actually I stopped the Log shipping Backup job and also I disable the replication jobs but still every 10 minutes,slowness happens...

GSquared (12/22/2011)

---

SQLRNNR (12/21/2011)

---

Those are the old non-ansi style Outer Join references. This was deprecated in SQL 2005. The upgrade advisor in 2005 will inform you of this joins...

Nice work thanks. I added this to my briefcase for future reference.

Woohoo - awesome steaks for the holidays

Thanks for the question.

Reindeer Steak

Happy Holidays to one and all.

And to others, 10 SSC points for this reference:

jcrawf02 (12/21/2011)

---

anybody watch Animaniacs? Reminds me of the one where they're talking to Einstein, and he's "calculating the speed of light" by pulling the chain on the lamp with one...

Tum Tum Tum Tum Tuuuuums

relief

Your replication speaks to the wait type ONDEMAND_TASK_QUEUE. It could also contribute to the occasional slowness.

Blocking occurs within SQL Server. You will need to look in SQL to...

As the link indicates - you cannot without trying to do a .Net workaround.

Those are the old non-ansi style Outer Join references. This was deprecated in SQL 2005. The upgrade advisor in 2005 will inform you of this joins and give...

If you don't have documentation stating what the servers are, then you will probably need a net admin to help you identify all of them. There are tools (sqlping2,...