Steve Jones - SSC Editor (5/30/2016)

---

Terje Hermanseter (5/26/2016)

---

However, I like Kimberly Tripp's advice. Choose the clustering key separately from the PK, keep it unique, fixed, and narrow..

I'm not sure I fully understand the "choose the clustering key separately from the PK" part. I thought it was perfectly ok to use the PK as the clustered key as long as it fulfills the other criterias: keep it unique, narrow, static, ever-increasing and fixed width?

It is, but you're choosing them separately. You're picking a PK based on some unique criteria. You're looking at a clustered index as being narrow, static, increasing, fixed. If they match up, great, but you choose them separately.