Interview Questions
1. What is the use of having multiple File Groups?
Below are the major benefits which can be achieved using multiple data files and placing these files in separate file groups on separate disk drives.
1. Disk I\O Performance
2. Easy Management and Archiving of the data
3. Benefit of doing File Group level Backups and restores
4. Usage of File Groups in Portioning of the tables
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment