Paul White (6/29/2009)

---

Well...

You'll have to define the context in which you're using these terms. For example, you say comparison and I think that you're referring to the WHERE clause or the JOIN...

If this is a reporting system, it might need a larger tempdb. It's not just virtual tables (by these I assume you mean temp tables and table variables) that use...

They should be good articles. They're taking the RSS feeds from all the best blogs and posting them up without attribution and frequently without links. It looks like this place...

GilaMonster (6/29/2009)

---

Personally I prefer to run all test queries twice and ignore the times of the first result. That way, what I'm...

Peso (6/29/2009)

---

One would think that using the index with most columns would minimize the risk of having to bookmark and use key lookup later in the execution plan.

But on the...

I'm not sure I'd call it proper since I occupy it, but,...

RBarryYoung (6/28/2009)

---

Jack Corbett (6/28/2009)

---

GilaMonster (6/28/2009)

---

Lynn Pettis (6/27/2009)

---

Okay, you were between 6 and 10 when I learned that in University. Not exactly when or which school I was in when...

mike_walsh (6/28/2009)

---

Hey Grant - I understand what you are saying but I am not 100% sure if I follow with this situation. Follow along and smack me around and tell...

Paul White (6/28/2009)

---

Grant Fritchey (6/28/2009)

---

Every time I ran the query, it picked the widest set of includes, regardless of the order in which the indexes were created. I didn't check...

I'm not sure...

GilaMonster (6/26/2009)

---

Grant Fritchey (6/26/2009)

---

I wanted to be sure of the answer before I posted it, but it seems that SQL Server will most frequently pick the index with the most...

David.Poole (6/26/2009)

---

We have an experienced architect who has worked with agile development for a number of years.

He has some pearls of wisdom

1. It takes 18-24 months for the agile methodologies...

mike_walsh (6/26/2009)

---

Did you ever solve this one? I am having a similar experience and it is puzzling enough that I might log a case with MS Support to better understand...

Once you get the indexes in place, I'd suggest that a TOP with an ORDER BY is going to be more efficient in this situation than the MAX that you're...