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

But the WHERE clause in that query will more or less always force an INNER JOIN. If you're filtering by the Child records, then that's what you're filtering by. The...

Gaby A. (12/24/2008)

---

dford (12/24/2008)

---

Lot of good responses here. I have to say, I don't like seeing lopsided articles about getting rid of cursors. They exist still partially because...

Thinking about it a bit more, you could combine older versions. Anything released 10 years ago or more will go into a "Previous Versions" folder with a the same four...