I would say the difference is probably attributable to statistics. If you look at the end of the process, the scans & reads for the two are VERY different. For...

I agree with this. I have three of Henderson's books sitting on my shelf right now. Unfortunately, they're beginning to age...

Lin Zhang (12/30/2008)

---

You are right. But I mentioned that you need to do backup ( transactional backup) before change recovery mode, and do full backup after changing mode back to...

Yeah, I'd like to see some information too. What the heck are you moving data into tempdb for? SQL Server puts enough of a load onto the tempdb without adding...

Lin Zhang (12/29/2008)

---

Before rebuild index, backup you database ( just for caution), change your database recovery mode to *simple* so that the rebuild index operation will not be logged, you...

Then I'm really confused. If you drop the WHERE clause, your initial query should have worked.

RBarryYoung (12/29/2008)

---

For what it's worth, I think that one exercise that we should all try is to seriously consider what good the forum Taxonomy/Structure truly does for each of us...

You don't have access to system tables in 2005. Those are views that you're seeing.

I wouldn't do something like that on a bet, especially on a production system that I...

I can't say that I've seen that. Any time I thought it was wrong, upon further investigation, I found that it was correct. For example, maybe your default connection database...

joshcsmith13 (12/29/2008)

---

I definitely support Topics at the top level. I can't count the number of times I needed to post a T-SQL question, and couldn't decide if it should...

But that is just the same OUTER JOIN that the OP wrote in the first post. What...

Itzik Ben-Gan has three that I highly recommend:

SQL Server 2008 T-SQL Fundamentals - It's 2008, yes, but it's very introductory and applies almost completely to 2005.

Inside SQL Server 2005:...

Nah, don't sweat it. I thought it was a strange reply, but I didn't get upset.

I'm still confused by the concept of a thing that is absolutely used for identification...

Let me first say, this is just my opinion. Others can, and probably will, disagree.

The question for me is, do you want to stay a geek or let those skills...

If you want to see each statement within a query as it executions use a trace (or Profiler on a non-production system), to capture the statement completion events :SP:StmtCompleted and/or...