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 - 2010-12-03 : 11:17:03
|
| Good morningi have a table namaed tablex, i know that a table has only one filegroup but no in 2 FG. DOESNT IT?in SSMS tells me that tablex is in FG x and using sp_help tablex tells me the that object is storaged in that FG. i apprecita yor help |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2010-12-03 : 11:33:53
|
| Don't understand.Sounds like you have a table in filegroup x and sp_help and SSMS agree.==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-12-03 : 13:04:11
|
| Is your table partitioned?A partitioned table can live on multiple filegroups. A table that is not partitioned can only reside in a single filegroup. |
|
|
|
jeffw8713
Aged Yak Warrior
819 Posts |
Posted - 2010-12-03 : 16:00:24
|
| If we are only talking about the clustered index - then yes, if it is not partitioned it will be in one filegroup. Non-clustered indexes can be in other filegroups. |
|
|
|
alejo46
Posting Yak Master
157 Posts |
Posted - 2010-12-04 : 18:08:51
|
| Thanks a lot, but how do i know a table is partioned? is any other sql command ?. you said Non-clustered indexes can be in other filegroups, so ie when i use the command sp_help tablex it shows the properties of the table, right? if the table has thos kind of indexes (Non-clustered indexes) menas the table is partitioned?i appreciate your help |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
|
|
|
|
|
is it possible that a user table is in 2 filegroup