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 |
|
fmardani
Constraint Violating Yak Guru
433 Posts |
 Posted - 2006-08-14 : 03:37:26
|
| Hi,There is a table which is about 50GB is size.I am thinking of placing the database of this table into a separate .ndf on a separate drive on the server.Is it possible to place this particular table into a searate drive to increase the performance even more?Basically my question is: is it possible to place tables into separate .ndf files?Thanks |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-14 : 07:38:32
|
| You can add a filegroup to a database which is held on a physical file or files. You can then place a table (and or indexes) on that filegroup which will place it on that disk.You can't place anything on a file whithin a filegroup - so adding another file to the existing filegroup won't work.You create the table on the filegroup or move it to that filegroup by moving the clustered index.Have a look at filegroups in bol.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
fmardani
Constraint Violating Yak Guru
433 Posts |
Posted - 2006-08-14 : 08:47:04
|
| So, does this mean that tables will automatically be placed in the same .ndf as the database? i.e. all the objects in that database will be in one .ndf? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-14 : 09:28:21
|
| If you only have one filegroup (the default) and on file then yes.If you have one filegroup and multiple files then it will balance the file usage.If you have multiple filegroups then you can specify where the data is held - it will default to the default filegroup if you don't specify anything.Have you looked in bol - this is all covered there.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Filegroup