Thanks to both. Glad to hear it's useful.

Jeff Moden (4/13/2012)

---

capn.hector (4/13/2012)

---

ok on topic: http://www.sqlservercentral.com/Forums/Topic1283271-392-1.aspx how do you long time posters keep going when you run into people like this. (one thread there are more...

zojan (4/13/2012)

---

Sean Lange (4/13/2012)

---

jzoran (4/13/2012)

---

If the request is reduce time of execution from 20 min to 20 sec the only one possibility is checking indexes (missing indexes or it could...

Evil Kraig F (4/12/2012)

---

Koen Verbeeck (4/12/2012)

---

GilaMonster (4/12/2012)

---

I'm getting very frustrated (and very saddened) by the (apparently) increasing number of people who seem to feel that writing T-SQL is about throwing...

Execution plans show you the decisions made...

If you're getting bad plans, it can still be because of the stats.

If the plans you're getting are working in an inconsistent manner, then recompile might not be the best...

DBA_Dom (4/12/2012)

---

Grant Fritchey (4/12/2012)

---

Personally, I don't recommend using it. Instead, capture the query metrics using a server-side trace, then load those metrics into a database back in your development environment...

Not much. There'd just be a few more unchallenged suggestions that...

pallavi.unde (4/12/2012)

---

In one interview the guy asked me a question regarding query performance as below,

Suppose i have one big query which is taking 20 minutes for execution, how could i...

Oh lord, I think someone either has a homework panic (as seems to be standard around here) or is WAY over their heads at their job. They want me to...

Again, I won't do it for you. If this is homework, you need to do it yourself. If you're getting paid for this, then you either need to pay me...

Thinky Night (4/12/2012)

---

Thanks All,

New questions:

If there is a mixed extent, Must it contain a Shared Global Allocation Map (SGAM) Page and Page Free Space (PFS) Page?

And

When a new extent...

call.copse (4/12/2012)

---

Thanks Grant. I'll have a look through your ebook and see where I get to. I guess the tricky bit (from my perspective) is getting the branching right when...

Seriously sounds like homework. If I do everything for you, do I get the grade?

I built the database used by the US Tennis Association back in the 90's (I've heard...

If you're going to try to tune the query, you really need to get a look at the execution plan. That's a first step.

And to reinforce, NOLOCK is absolutely not...