It /should/ work very well. However, here are some "oh yeahs" rather than "gotchas" to help you along your way.

A) Make sure you have all of your service account permissions...

I'll also add that you -do not want- to change the path of master/msdb/model for future compatibility reasons. Moving tempdb is a non-issue; Pinal Dave has that script language readily...

I dont necessarily think so - I think you were eluding that NCI's had an opportunity for improvement. In my case, however, NCI's are very little, no more than a...

Care to expand on your suggestion? I totally recognize the need/value in isolating ANY of the data types/models for improving IO performance. However, even if a file were to have...

It's Sharepoint - so all of the schema is as provided by mother Microsoft. I have not tried using another filegroup, perhaps initially out of support concerns, but also due...

Submitted as BUG 692793

I have not, i mostly lurk the forum so I don't really know how it works 🙂

[SOLVED]

Creating Indexes with "ONLINE = ON" repeatedly reduces compression effectiveness as significantly as 50%. I have made numerous copies and backups over time and restored them to various servers on...

The attached has been sanitized of any secret sauce - this is a 3rd party product so i can't be giving away their design.

See attached. There are two tabs.

I've never used the detailed view of sys.dm_db_index_*_stats

I have confirmed that without any doubt, the table (and index) schema has not changed in any way. I was considering opening an MS support case - but i'm not...

Honestly, it's entirely random. There are 8 or 9 columns that have a high on/off null requency. But the data width is small, dates, 5-6 digit entries, etc. No big...

I listed all data types, so no risk of blobs or anything messy like that. The data change are insert-only, there are no updates/changes as this is reference data for...

I (re)wrote their data migration package to an extent - I took out all of their index operations and perform them as before & after steps in an Agent job....

Fortunately, the purpose of this table is a date-based archive. Entry dates for accounts receivable transaction data are key to identifying the data outside of the primary key (identity column)....