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...

Does this give the expected outcome

CREATE TABLE #Surgery

(CaseID int,

Patient VARCHAR(10)

)

INSERT INTO #Surgery VALUES

(101,'SallyDoe'),

(102,'JohnDoe')

CREATE TABLE #Anesthesia

(

CaseIDINT,

CrnaID VARCHAR(10)

)

INSERT INTO #Anesthesia VALUES

(101,'Melvin'),

(102,'Bart'),

(102,'Jack')

CREATE TABLE #AnesthesiaTime

(

CaseID INT,

CrnaID VARCHAR(10),

TimeIn CHAR(4),

TimeOut CHAR(4)

)

INSERT INTO #AnesthesiaTime VALUES

(102,'Jack','0800','1030'),

(102,'Bart','1030','1130'),

(102,'Jack','1130','1215')

;with...

Table

You can use xp_logininfo to enumerate the members of a group

EXEC xp_logininfo 'DOMAIN\GroupName', members;

The following will find all deny permissions on objects

select

accounts.name AS UserName,

OBJECT_NAME(major_id) AS Object,

permission_name,

state_desc

from sys.database_permissions perms

inner join...