Browse by Tags

• databases
• dbcc
• files
• object_name
• sql server
• tablename
• tsql
• usage

SQL Server- TSQL to see which object reside under which file groups?
24 December 07 03:40 AM | SQL Master | 3 Comments   

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', Read More...

Filed under: tsql, sql server, object_name, filegroup, tablename, files

How can you tell how full a file in a filegroup is?
03 August 07 03:09 AM | SQL Master | 1 Comments   

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 Read More...

Filed under: databases, dbcc, filegroup, usage