Bob Hovious (2/25/2009)

---

Hey G 🙂

It's not barrier to entry. Nobody has to take a test on the material. It's just something that first time...

Which makes my prior post the "Party with Prince" post! Woot! 🙂

Can you post the execution plan? Save it, zip it, upload it.

matt stockham (2/25/2009)

---

You mean if...

The main resource I used when learning T-SQL was "The SQL Server 2000 Bible". I'd use the 2008 version these days, or maybe 2005, but it's that series that...

As an addition to this, there have been plenty of questions that "violated the posting practices", that I was able to help out pretty easily. Some questions require much...

Bob Hovious (2/25/2009)

---

Steve, a suggestion: Why not expose first time OPs to a best practices for asking questions link BEFORE they enter their question. Just pop it...

I think you can configure the report field to remove decimal places. Could be wrong, but I think I remember doing that at one point.

You can get Visio to diagram a database pretty easily and use that to print, export, etc., files.

RedGate also has a product that can do a pretty good job of...

I recommend taking a look at the section in Books Online on Common Table Expressions. There's a very good example in there of resolving this type of hierarchy.

Yeah, that should be fine. Shrinking might cause more of a lock, but growing isn't usually a problem.

Lots of whitespace is good. Every survey on document layout agrees on that point.

I have to admit to being lazy about formatting and capitalization. I have a relatively consistent format, but I can't say that it's the easiest to read.

I can't recommend a text editor. I type 100+ words per minute, so haven't found much use for intellisense, shortcuts, et al.

XML won't show in the forums. Attach it as a txt doc, please.