Question about filegroup usage

[pandatime]

Hi,

This question came up for me today, and now I'm not sure what the answer is.

Let's say you create a table in a database comprised of multiple filegroups. By default it will use the "primary" filegroup.

But let's further assume that the "primary" filegroup is mostly or totally full. So, where will it create the table then? That is, how does it "choose" which filegroup to put the data, and is there a way to VIEW which filegroups on which a specific table reside? This would be very useful to view, I think.

Thanks much!

 

[pandatime]

Or perhaps, another way to put this question is,

Can a table span multiple filegroups WITHOUT being partitioned? That is, does table data "spill over" to other filegroups when the primary is full? (assuming that's where the table was created)