Now when you say SQL Server is taking all the available memory do you mean it's actually using all the memory and running into performance issues? SQL Server will...

Is there a problem just letting them query the column directly?

Eric M Russell (2/25/2015)

---

ZZartin (2/19/2015)

---

Eric M Russell (2/19/2015)

In the original post, it was stated that table contains no primary key. Regardless of what the table contains (datatypes or internal value...

A sample size of 1 run per setting is pretty meaningless.

How wide is the table, how sparsely is the data populated, how many indexs are on the target table? Millions of rows doesn't necessarily mean a huge data size,...

Eric M Russell (2/19/2015)

---

ZZartin (2/19/2015)

---

Eric M Russell (2/19/2015)It's unclear how a table containing only Title + Author, and duplicates allowed, would be used by an application. If someone wanted to...

Eric M Russell (2/19/2015)

---

ZZartin (2/19/2015)

---

Eric M Russell (2/19/2015)

---

ZZartin (2/19/2015)

---

Eric M Russell (2/19/2015)

---

ZZartin (2/19/2015)

I don't disagree that most tables probably will and should but there's certainly cases where you might not...

Eric M Russell (2/19/2015)

---

ZZartin (2/19/2015)

---

Eric M Russell (2/19/2015)

---

ZZartin (2/19/2015)

I don't disagree that most tables probably will and should but there's certainly cases where you might not have a need for...

Eric M Russell (2/19/2015)

---

ZZartin (2/19/2015)

I don't disagree that most tables probably will and should but there's certainly cases where you might not have a need for or a possible primary...

Eric M Russell (2/19/2015)

---

ZZartin (2/19/2015)

---

Eric M Russell (2/19/2015)

---

Grant Fritchey (2/19/2015)

---

shane.green 1227 (2/19/2015)

---

There are exceptions to every rule, so while "All tables should have at least one index" is good rule...

Eric M Russell (2/19/2015)

---

Grant Fritchey (2/19/2015)

---

shane.green 1227 (2/19/2015)

---

There are exceptions to every rule, so while "All tables should have at least one index" is good rule - it doesn't mean...

If you think it'll improve performance, and it likely will if there's no specific reason she thinks it won't, then prove her wrong that's what dev environments are for 🙂

What were her reasons why? And what were your reasons for wanting to add a clustered index?

A clustered index does not automatically improve performance and there may already be...

And all this even more muddy when you start getting into the realm of VM's and one set of discs might be shared across not only multiple drives on a...

If you're wondering whether canceling the job will cause a problem no it shouldn't, it just won't have had any affect on indexs that either weren't reached or the process...