Thanks for your response

Thanks for your reply,so which option is good for reporting services.

Thanks for your reply

Thanks for your reply,but if all the data in single file vs splitting data in file groups by portioning which is better ? this is the reason i choose for...

Thia table contains 7 months worth of data ,it will not make any performance difference if i split data on monthly basis ?

Total record count :54812769

Colc --- date column

purging will be monthly

partition we considered for performance obtain