It's using the index on SiteMap2 that has both columns because that makes it a covering index.

Don't use the cost estimates as a measure of query performance. They really...

SQL Agent in Books Online

Performance Monitor counters

Performance Monitor Counters

4.HOW TO TRUNCATE TRANSACTIONAL...

It is very possible to over-use temp tables and table variables. A lot of developers will load data into a temp table and then go through various joins to other...

Yeah, that's a huge query and it's going to take a long time to compile. What's more, the size of it, the number of tables it hits, it's going to...

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...