GilaMonster (11/12/2009)

---

bob 54859 (11/12/2009)

---

So, the dev in our shop that is against this claimed that when he did this a select query was 10x slower and SQL chose the wrong...

SQL Noob (11/12/2009)

---

bob 54859 (11/11/2009)

---

Ok,

So... here is a question we have debated in our shop for quite a while.

The question is...

Given a table where they is no good candidate...

hlam-1032421 (11/11/2009)

---

Some considerations:

1.Size of table and growth rate.

2.Primary needed for speed of replication?

3.OLTP vs. Data Warehouse like

4.3rd normal form vs. Demoralization?

5.Contention with other servers and process?

Sometimes you may want to...

Ok,

So... here is a question we have debated in our shop for quite a while.

The question is...

Given a table where they is no good candidate for a clustered index,...