GilaMonster (10/28/2010)

---

Normalise fully. 4th normal form is probably a safe place to stop. Denormalise as necessary and with good reasons. Not bothering to normalise past 1st is not denormalisation, it's...

Paul White NZ (10/27/2010)

---

Spackle is a very local brand name, probably unheard...

Jeff Moden (10/27/2010)

---

You shouldn't mention that in an SQL forum: "Row" is unspeakable, think...

Very well deserved. The inclusion of this "musr see" session...

Stefan Krzywicki (10/26/2010)

---

I was hoping to have a discussion of the different methods and maybe some links to documentation so I could read more on something I hadn't found much...

An easy example is a set of places...

You can shrink sql2000 log files from enterprise manager, don't need to script it. But note that it won't get you anywhere unless you've firsdt got rid of outstanding...

I agree with Pavan. Usually when the transaction log is too big there's a reason for it and shrink will not reduce its size.

If the recovery model is anything...

Try looking at select ....for xml path ("")

Sean Grebey-262535 (10/25/2010)

---

I have an existing query in place that I use to sum totals for various codes we do business under. So for example any code in the 600...

CirquedeSQLeil (10/25/2010)

---

Alvin Ramard (10/25/2010)

---

CirquedeSQLeil (10/25/2010)

---

Alvin Ramard (10/25/2010)

---

Stefan Krzywicki (10/25/2010)

---

Steve Jones - SSC Editor (10/25/2010)

---

Some people are definitely not sure about how to research something, or unwilling to try. Or they...

I'm definitely one...

What is this American thing with offices and status? I really don't understand it. I've spent equal amounts of...

Presumably brandybutter as it's Brandie's biscuit? Not sure how well honey goes with that, though.

Nice straightforward question. Thanks.