Tag Info

New answers tagged

2

Supplementing to @MaxVernon's answer, there are some optimizations that you can do : Use different filegroup for staging tables and make sure the filegroup is on a different physical drive (or LUN). Use Instant File Initialization as well as have a proper autogrowth setting. I have a handy script to analyze autogrowth events. Since you will be emptying the ...


2

Putting those staging tables on their own filegroup allows you to do piece-meal restores. This helps get the database up-and-running more quickly in the event of a disaster recovery effort. Having those tables in their own filegroup will allow you to place them on their own set of disks which may increase performance.



Top 50 recent answers are included