title: How to find type and size of content of a filegroup in SQL server?
body: <p>I have a database using two filegroups. Let's call them PRIMARY and FG1. All data was originally in PRIMARY and then moved to be in FG1. This was achieved by moving the clustered indexes to FG1. The other indexes were removed and recreated without specifying a file group, but FG1 was defined as default so they are now effectively in FG1.</p>
  
  <p>However, the file for PRIMARY still gets filled over time.</p>
  
  <p>How can I find the type of stuff that remains in PRIMARY, including its size?<br>
  My goal is to get really everything over to FG1 so that PRIMARY doesn't get filled anymore.</p>