Jan Van der Eecken (3/5/2009)

---

Now, that's interesting Gail, any official MS evidence to back this up?

Bruce W Cassidy (3/5/2009)

---

(also from my experience) dates aren't good candidates for clustered indexes as they require a "uniquifier".

Marios Philippopoulos (3/5/2009)

---

I think usage is an important consideration, especially when the table is large.

Marios Philippopoulos (3/5/2009)

---

Based on the above info, should I be making the last index, UC_tblName_col1, clustered?

Derek Dongray (3/5/2009)

---

Also I'd be interested to see the source of the User-defined function FFG_FX_JUST_DATE since, although it doesn't add the the estimated cost

rmechaber (3/5/2009)

---

Would you recommend as a best practice that I include a Shrinkfile for the log in my daily Agent backup job?

rmechaber (3/5/2009)

---

I thought that Simple recovery mode wiped the transaction log on a full backup

Steve Jones - Editor (3/5/2009)

---

I suggested he post the thread in the MVP groups and see who was acting unprofessional.

Chris Morris (3/5/2009)

---

Hey Grant, your chum's back in town. I'm in the bleachers with a couple of beers.

sql-oholic (3/5/2009)

---

I was hoping to get some tips & tricks .. best practices when using temp tables in sproc