Thanks for the feedback sir!

g.britton (7/14/2015)

scorchpc 96170 (7/14/2015)

g.britton (7/14/2015)

depends what you mean by preserves data types....

g.britton (7/14/2015)

depends what you mean by preserves data types. Can you...

Hi,

I am curious.

Are you able to automate the creation of an Excel file that preserves data types?

I tried, but still the DB just grew. Oh well.

DECLARE @TableName VARCHAR(255)

DECLARE @sql NVARCHAR(500)

DECLARE @fillfactor INT

SET @fillfactor = 80

DECLARE TableCursor CURSOR FOR

SELECT OBJECT_SCHEMA_NAME([object_id])+'.'+name AS TableName

FROM sys.tables

OPEN TableCursor

FETCH NEXT...

Hi Paul,

Q: Do all affected tables have a clustered index?

A: No

Q: In the affirmative case, was each one of such clustered indexes rebuilt?

A: Assuming the script I posted works,...

FYI

I have a smaller server in China that wasn't as bad, but could still use this.

I tried rebuilding the indexes on just the affected table only, it helped a bit,...

will do, I'll let you guys know the results

Thanks again!

Hi Paul and Mike,

Do you guys think I should rebuild all indexes on all tables? Or just indexes on the affected table?

I am thinking all indexes on all tables really...

Thanks for the fast responses guys.

I suspected something like this. The next time no one is working, I will backup the DB then try the above advice.

Thanks again!