nitin.varshney (6/12/2013)
is it the right thing to add the newfilegroups in the database ?
Depends what you're trying to achieve. Maybe yes, maybe no.
We want to create the partition for the performenance prospects.
Then don't waste your time.
https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability