• to add to Gail, in fact in some cases if you have a large number of files per filegroup the file switching can be a performance issue. SQL Server attempts to stripe when multiple files are implemented per filegroup, this has to be monitored and calculated ongoing so that sql server knows exactly how full a particular file is.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉