SSQA.net

Whenever you perform a database creation, add a data or log file to database, AUTOGROW process is intiated or restore of database will trigger the file initialization if that is created afresh.   In addition to this when you talk about files intialization you must consider the hardware such as RAID, as the software data block ...

To continue the FIND-FilegroupFull post on the filegroups, here is the most common question on the forums to get which object reside under which filegroup if there are multiple ones associated:   select si.rows as 'Rows', SO.Name as Table, SI.name as 'Index', SFG.groupname as 'Filegroup' from sysobjects as SO    join ...

Filegroups use a proportional fill strategy across all the files within each filegroup. As data is written to the filegroup, SQL writes an amount proportional to the free space in the file to each file within the filegroup, rather than writing all the data to the first file until full, and then writing to the next file.   Using ...

Here is the script I have used to list the information regarding database objects such as tables, indexes and file groups along with their file names :    (extracted from Technet) select 'table_name'=object_name(i.id)  ,i.indid,'index_name'=i.name  ,i.groupid,'filegroup'=f.name  ...