Chad Crawford (10/4/2010)

---

Has anyone ever picked up the DVD from PASS Summit? Does it have all 150+ sessions recorded, or is it just one DVD with select sessions...

Doesn't really matter does it?...

Rob Schripsema (10/4/2010)

---

(Just posted a similar comment on Glen Berry's blog at http://www.sqlservercentral.com/blogs/glennberry/archive/2010/3/22/why-uniqueidentifier-is-a-bad-choice-for-a-clustered-index-in-sql-server.aspx. This is not meant as a double post, just not sure if responses to older blog articles...

Until you get into the third party tools (my favorites, in no particular order, are Red Gate SQL Response, Confio Ignite, Idera Diagnostic Manager), then I'd suggest a combination of...

You might be looking for the DMO sys.dm_exec_query_stats. It contains an aggregation of the performance of the queries currently in cache. You can also look at sys.dm_exec_proc_stats in 2008.

I'm assuming you're not talking about disaster recovery (DR)?

Just for tuning performance, first thing I'd do is set up data collection to get a good set of metrics from performance...

Matt Miller (#4) (10/4/2010)

---

Steve Jones - Editor (10/4/2010)

---

david_wendelken (10/4/2010)

---

...

So, rather than piss and moan about not getting equal pay for equal work, why not learn what career and job negotiating...

sql_er (10/4/2010)

---

I think some of this was mentioned to some extent in the replies, but here are my two cents:

1. Subtree cost: Not sure how often people use this, but...

Jeff Moden (10/4/2010)

---

Dave Ballantyne (10/4/2010)

---

Still cant believe that my name is sitting on the same agenda as all these MVPS , MCM's (yes plural , the universe doesnt collapse if...

Jeff Moden (10/4/2010)

---

Dave Ballantyne (10/3/2010)

---

Thats sqlbits all over with now , great conference. My talk seemed to go pretty well, room full of blank faces when i asked...

Hey Wendy! Excellent editorial. 110% agreement. You really couldn't have put it any better.

BTW, regarding boys & girls & toys, I have twins, one boy, one girl, our intention was...

It depends on how your views are put together. If they're all simply "SELECT *" type of views, then they more or less fix themselves as they are referenced. On...

No, no, no. We don't call it cheating. We call...

Hey guys, thanks for dumping a load of... something into my in box. What the heck were you guys smoking in here last night?

I really hate the DTA. Piece of Marketing if you ask me.