First things first, estimated costs are not measures that you can compare between queries. They are too subject to odd variability, so don't look at cost estimates within execution plans...

PiMané (10/11/2012)

---

One more if I may Grant...

I've already discussed this point but if you can enlighten me a little more I'd be grateful 🙂

Suppose I have an index I1...

PiMané (10/11/2012)

---

ScottPletcher (10/10/2012)

---

The nvarchar(20) does make that a problematic clustering key, but it still depends.

A three-column is not slower to do lookup on if that's what you (almost) always specify...

PiMané (10/10/2012)

---

Grant Fritchey (10/10/2012)

---

On a table that is stored as a clustered index, the non-clustered indexes use the key values of the clustered index as lookup values for the columns...

PiMané (10/10/2012)

---

Hi,

I was reading about PK and Clustered Indexes over at sqlskill.com and after reading too much I guess I burned a fuse...

So pardon if this is a stupid question...

The...

Jeff Moden (10/6/2012)

---

Heh... Roger that! God bless Navy training!

Someone on this thread asked what I looked for on resumes and my answer was that I basically interview anyone that...

Jeff Moden (10/5/2012)

---

Evil Kraig F (10/5/2012)

---

Nadrek (10/5/2012)

---

CptCrusty1 (10/5/2012)

---

These two candidates come as stark contrast to each other. Both have Advanced Degress, hers is technology related, his is an MBA,...

Jeff Moden (10/5/2012)

---

If I hadn't actually been through it, I'd absolutely...

ERStudio from Embarcadero is my preferred tool.

I don't agree with the initial construct. I've seen plenty of indexes with compound keys work perfectly well for performance without the need to add another column and another index...

patrickmcginnis59 (10/2/2012)

---

Grant Fritchey (9/21/2012)

---

Lowell (9/21/2012)

---

ok, I have my own my knee jerk reactions for the things to review.

Grant wanted to avoid putting the answers on the forum, but i'd kind...

Koen Verbeeck (9/28/2012)

---

laurie-789651 (9/28/2012)

---

Koen Verbeeck (9/28/2012)

---

If you do...

anthony.green (9/28/2012)

---

I missed the London one's due to...

And that's why we test.

The thing with trying to filter NULL values is that you're doing a function on it no matter what. By their nature, NULL values have no...

When I've done it in the past, we were usually doing server consolidation, so we looked at the load on the server. We didn't break it down much by database...