How come?? Never bothered to learn it but...

This monitors jobs & blocking.

Free 14 days trial + available 14 days extension

http://www.red-gate.com/products/dba/sql-monitor/

GilaMonster (10/26/2011)

---

Or I can do a remote perf review, or...

HTH & welcome to our little world!

jshurak (10/26/2011)

---

thanks. I followed Gail's performance articles when initially researching this issue and grouped by highest total. I tuned the highest offender with the missing index but it unfortunately...

You're right. The information so so much wronger in the ebook version.

Wait another month before you get the "good" stuff.

:hehe:

P.S. Did I mention you're wife is right?

#1 get a copy of prod to your dev/qa machine.

#2 http://www.sqlskills.com/BLOGS/PAUL/post/Page-Life-Expectancy-isnt-what-you-think.aspx

#3 Keep tuning with this. Group & Sort by highest reads / writes and tune the worst offenders...

In ssrs 2005 I'm able to add a calculated field in the dataset as x1 and then another 1 as x1 + 1.

Then you can use those in the tables...

Thanks for the info.

As I said earlier, not really expert in xml :-).

BrainDonor (10/26/2011)

---

Available now over there, but not over here. By the time it was shipped over I could probably get it over here now and that also requires some additional...

spidey73 (10/26/2011)

---

I really don't know why. I inherited these servers and I never gave it a second thought.

(lame excuse, I know)

But,...

Why do you choose to not run the full checkdb?

Available NOW

http://www.manning.com/delaney/

Thanks for the legwork Chris.

@StaintGr8, please notice how you can run the inner queries simply by highlighting then and hitting F5 (excluding the correlation... can't do that with the CTE...

Check the performance of that VS 2 outer applies.

CTE can become costly real fast when not used correctly and I think your setup is not optimal (going to members more...