jay holovacs (11/12/2010)

---

Or knowing the difference....

Congrats on the millennial mark!

GilaMonster (11/11/2010)

---

GSquared (11/11/2010)

---

Another way is to have a multi-column clustered index, and to include those same columns in a non-clustered index. Since the clustered index is automatically included, duplicating...

;WITH CTE (ID, ParentID, TopID) AS

(SELECT CategoryID, ParentCategoryID, CategoryID

FROM dbo.Category

...

WayneS (11/11/2010)

---

Well, I'm off to give my first presentation of "Comparing Tables Variables and Temporary Tables" to my UG tonight. Wish me good tidings, smooth talk, and all the other...

Because 1 bit of data only stores on/off, not "on/off/negative-on". Some use -1/0, which is essentially the same thing. Some allow 1/0/-1, but that means they're using more...

Pillow ?= Keyboard

I agree partially. If his "car-on-demand" or "just-in-time-car" or whatever you wanted...

Sean Lange (11/11/2010)

---

David.Poole (11/11/2010)

---

This is on my list of "stupid things no-one in their right mind would try" and I apologise to any DBA for revealing how you do this.

EXEC...

Good. Had me worried for a bit there.

It should only grow through either transactions, or someone deliberately growing it.

David.Poole (11/11/2010)

---

WHERE s.column >'' will be marginally more efficient than WHERE s.column<>''

Nulls are sometime necessary, for example if I have a DrivingConvictions table in a car insurance database I might...

Are the queries different?

Wildcat (11/11/2010)

---

GilaMonster (10/28/2010)

---

Hint: What makes a clustered index different from a nonclustered index?

Yes, it may be possible with work to make a nonclustered index larger than the cluster, it's not...

You're welcome.