Thank you for all of the suggestions. Very helpful.

This is a vendor's database, so I don't have control over the structure. Well, I mean I do, but I don't want to think about the nightmare that would ensue...

RVSC48 (9/21/2016)

---

Hi Mike,

What Statistics option if any are you using in the Ola index command?

ALL - Update index and column statistics.

INDEX - Update index statistics.

COLUMNS...

Very good question. Yes. The vendor has...

TheSQLGuru (9/24/2016)

---

1) Why limit yourself to 32GB RAM? SQL 2014 Standard Edition can hold 128GB

2) Why mess with tempdb at all? Have you identified tempdb allocation issues as a cause...

Gail,

I was following Paul Randal's advice in his article about TempDB here:

http://www.sqlskills.com/blogs/paul/correctly-adding-data-files-tempdb/

Based on your response, now I'm starting to doubt that it makes sense to do that. What...

Grant Fritchey (9/23/2016)

---

Mike Scalise (9/23/2016)

---

Actually, not to belabor the topic, but would it seem reasonable to update all (non-index) statistics as part of the maintenance plan?

So something like:

1) DBCC CHECKDB

2)...

Actually, not to belabor the topic, but would it seem reasonable to update all (non-index) statistics as part of the maintenance plan?

So something like:

1) DBCC CHECKDB

2) Update all non-index statistics...

Thanks, Grant! That's very helpful.

Yes, I get it now, and that makes perfect sense. Thanks for the clarification--it really brings everything together for me. I'm looking forward to your presentation(s) at the PASS Summit!

GilaMonster (9/22/2016)

---

sys.master_files is, iirc, as-of the time that SQL last started, so if the DB's grown since then it'll be out of date.

2) Is it surprising that the ndf file...

Oh, my apologies. I didn't see that option. I do now.

So obviously I wouldn't want to run statistics after an index rebuild, but what about the non-index columns--do all of...

GilaMonster (9/20/2016)

---

Mike Scalise (9/20/2016)

---

However, if I add only a non-clustered index with ID as the key, then the table becomes ordered, much like it would if I created a clustered...

Thank you all for the responses. This is not a real-life scenario--it was just out of my general curiosity. I understand that best practice would obviously tell us to create...

Hi John,

Thanks for the reply. I have a few comments:

I know technically a table without a clustered...