Sounds interesting. Can you share the scripts you use? I can share my tuning experience once it's on my system ;-).

Here's another nice one :

My test is my job. This site is for learning...

Here's a demo. The whole topic is really advanced, but see the query he uses to get tempdb space usage (really simple) :

http://sqlblog.com/blogs/paul_white/archive/2011/02/22/Advanced-TSQL-Tuning-Why-Internals-Knowledge-Matters.aspx

cengland0 (7/27/2011)

---

None of...

holly crap.. there's even more future keywords than the current ones :w00t:.

How big's the db???

I could restore from last Chrismas to ten years from now will all the tlogs with...

http://sqlinthewild.co.za/index.php/2010/03/23/left-outer-join-vs-not-exists/

I'll ping in Gail to see if she wants to blog more about this.

Search for Adam Machanic's sp_WhoIsActive.

It'll give you that info and a ton more.

Could be done with the reportviewer control (sorry no direct link available). A good site for that is http://www.gotreportviewer.com/

With that you can force only 1 type of export or...

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

Once you find the offending queries post back with the actual execution plans if you need extra help solving those.

So bottom line Ray, if you take backup with checksum, after a successful checkdb(), then run verify (which passes) and then successfully do a test restore you can't possibly be...

And yet there's already 8 posts about it before 8 AM New-York time. 😀

dawryn (7/27/2011)

---

This is just a fowl joke :doze:

None as there is no Select as the code is given. There is no correct answer (0 is not...

Looks like it's Paul's day today... I'm so glad I caught this!