okay

After implementing -T1118 issue has been resolved.Thanks for your suggestions.

No Kevin ...Its just 1 GB I have set and with 500MB auto growth/Unlimited and all files are growing till 60 GB + and throwing disk is full.And always...

Hi Kevin,

1.It is SQL Server 2014 with SP1(12.0.4100.1)

2.We are not using Always ON and we kept default settings regarding isolation level which is read committed in 2012 and 2014.even we...

Hi Igor,

We tried compressing for future date ,In my case it is taking same time and not much difference, as jobs are running as Batch process but still we are...

Hi Igor,

Now we are trying to compress all partitions including future date (with and without rows),will it affect my performance ?? In this case while inserting data itself it will...

Hi Igor,

Thanks for your script, In my environment we have partitioned the tables with business_date column so we need to keep yesterday data uncompressed and all previous date should be...

Hi Alan,

Thanks for quick reply ...but my requirement is to keep yesterday data as it is and want to compress remaining partitions.