I never rebuild heaps, in fact we don't even allow them to be created.

Every table change has to be reviewed, in the off chance one slips past us there is...

No

Index ID 0 means the tables a heap, rebuilding a heap can be done, but all the nonclustered indexes also get rebuild to change the RID pointer.

http://www.sqlskills.com/blogs/paul/a-sql-server-dba-myth-a-day-2930-fixing-heap-fragmentation/

Rebuilding an index also rebuilds that indexes statistics.

I would recommend getting copies of Ola Hallengren's index maintenance and statistics script and seeing how he calculates what statistics needs updating.

What Jeff is asking...

Jeff Moden (11/4/2015)

Unfortunately, probably not for this one, Anthony. I will...

Old

How are you importing the spreadsheets? A for each file loop? If so you would have a variable to switch out the connection string to the spreadsheet.

I would...

Are the members of the group part of another group which has deny connect at the server level.

Can you post the full error message including the 18456 error state and...

No you could still rebuild offline, just need to add

INDEX_REBUILD_OFFLINE

To the list of options

Online indexing is an Enterprise only feature, so all you will ever get on a Web box with them parameters is reorganization.

Spinning

As long as the account in question has access to the share there shouldn't be no problems.

It depends, run the query filter out small page tables (page_count > 1000) filter out all heaps (index_id <> 0) what are you left with?

That details what in Microsoft's eyes...

Only thing I can think of is have two reports, one with all the formatting, one with just the data grid, then open the data grid in excel, or export...