That's a pivot operation. Do a search on it. I'm not great at them, so you'd be better off looking up what the real experts have to say.

Gianluca Sartori (6/30/2009)

---

GSquared (6/30/2009)

---

I read and mostly understood Frank Herbert's "Dune" when I was seven. I've been playing with the English language ever since, and it's quite a toy!...

GSquared (6/30/2009)

---

GilaMonster (6/30/2009)

---

GSquared (6/30/2009)

---

No more waiting required. Let...

I ain't singing and I ain't dancing, but I will take one of those particle accelator things please.

Heh. You really were skipped right by. Shame since you had the answer PDQ.

That looks like you're on the right track to me.

By the way, it's kind of a waste of space & time & readability to put 'tbl_' in front of table...

Well done Ken!

All those scans converted to nice seeks. Looks good.

I was never aware of a particular sweet spot in terms of compiles to batches. The fewer the better was the only rule I operated under.

jcrawf02 (6/30/2009)

---

Paul White (6/30/2009)

---

When I first read that, it sounded...

TheSQLGuru (6/30/2009)

---

1) I would imagine (hope) that the optimizer would choose the 'most-compact' covering index in the case where multiple indexes cover a query.

2) DTA and the missing index subsystem...

I agree. I wouldn't add that data to your Names table. You should go for a more normalized approach with a Subjects table and, like the last post said, a...

5 recompiles for 1000 batches is pretty good. 50% compile rate on your batches suggests that you've got lots of ad hoc queries. If it's a reporting system, that ratio...

For only 5, I'd say roll your own. You get most of what you need from Perfmon & server-side traces. Spending money on a tool for so few servers seems...

mjarsaniya (6/30/2009)

---

I am new to sql server .....but from this topic I understand/decide that ,

you are beginner or expert , first do best try to get answer from BOL and...

There really is no way to accurately assess how long a query will take to run. You can have a single row update that should run in about 5ms that...