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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 TableSpace

Author  Topic 

Sarat
Constraint Violating Yak Guru

265 Posts

Posted - 2004-03-03 : 17:33:30
Hi,
Does SQL Server has the concept of tablespace like Oracle?
Thanks,
Sarat


**To be intoxicated is to feel sophisticated, but not be able to say it.**

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-03-03 : 18:07:27
Refresh my mind what tablespace is in Oracle.

It might be like filegroups though.

Tara
Go to Top of Page

SQLboom
Yak Posting Veteran

63 Posts

Posted - 2004-03-04 : 05:36:15
tablespaces can be thought of like filegroups in sql server....u can think about keeping clustered (pk data) and non-clustered data (all index data, may be) in different filegroups
Go to Top of Page

Sarat
Constraint Violating Yak Guru

265 Posts

Posted - 2004-03-04 : 11:53:59
Awesome! Thanks ppl!

**To be intoxicated is to feel sophisticated, but not be able to say it.**
Go to Top of Page
   

- Advertisement -