Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
alejo46
Posting Yak Master
157 Posts |
 Posted - 2013-12-13 : 19:15:39
|
| Good evening:Its been said we cannot keep any object i.e table,index on this FG, so id like to know waht the reason is ?secondly if this fg had one object allocated in it how can i find another larger fg size with available space to move it ?Thanks in advanced |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-12-14 : 07:42:49
|
| hmm...Didnt understand what you're telling hereBy default PRIMARY filegroup would be the one which will be present for a db and unless you create another filegroup and explicitly specify it all objects, index created will be on Primary------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
|
|
|
Filegroup Primary Question