I usually turn it off...

Heh. Believe it or not, I still do Excel.VBA projects from time to time. Just finished one in November. 🙂

I am with you there, Matt. We wouldn't even have NULLs if Codd hadn't fought so hard for them.

Jeff Moden (12/31/2008)

---

Grant Fritchey (12/31/2008)

---

Even though SQL Server 2005/2008 will store excess values past the 8060 limit when dealing with varchar,etc., you will get performance overhead to go and do...

klini (12/30/2008)

---

RBarry says "Varchars only store that space that you are actually using"

but

Jeffrey says "whatever size you allow is the size that is going to be used"

Could I have some...

Good indexing & queries are usually all you need to address large tables successfully. If they really get too large, then you will want to look at partitioning the...

Oops, sorry I thought that I had checked for that...

Glad we could help.

Glad we could help.

Christian Buettner (12/29/2008)

---

RBarryYoung (12/29/2008)

---

Still waiting for your response to my question:

RBarryYoung (12/28/2008)

---

Christian Buettner (12/28/2008)

---

I might be nitpicking here...

Varchars only store that space that you are actually using.

Christian Buettner (12/30/2008)

---

The difference according to my tiny theoretical knowledge is that

a) you separate two or more statements with separators. (A;B;C;)

b) terminators end...

Select * from sys.types

Ah. OK....

So at 700 levels and say 10 million nodes, that would mean that each node had an average of 1.023 children? Wow, that's a pretty strung-out hierarchy.

What is the MLM industry and why would they need hierarchies that deep?