seperating tables in files - SQL Server Forums

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 Development (2000)

seperating tables in files

Author

Topic

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-01-22 : 04:23:52

i have a DB today with about 400 tables.
i understand that instead of 1 bnig files i can split them to
lots of files even for each table!
what is the procedure to do this?
and how from starts when i creat the DB i can seperate some of the tables into files?
thnaks in advance
peleg

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-22 : 04:31:03

What kind of information do you want to separate?

Peter Larsson
Helsingborg, Sweden

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-01-22 : 04:37:28

the tables them self
to put some of tables each table that will be in its own file and not
in the files of the DB that holds all the tables

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-22 : 04:46:11

I figured that out.
Do you mean the data or the definition or both?

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=73608

Peter Larsson
Helsingborg, Sweden

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-01-22 : 04:51:05

You mean to say you want to put tables on different filegroup? This will be beneficial only if your data files are on different drives (ideally RAID drives).

For this, you need to create different filegroups and assign each file to different filegroup. After this you can use Enterprise Manager, Table Properties dialog box or Alter Table statement to move table to different filegroup.

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-01-22 : 04:53:51

I would never had figured that out.
FILEGROUPS...

Since partitioning is for SQL 20005.

Peter Larsson
Helsingborg, Sweden

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-01-22 : 04:55:55

is it matter if iput in file only the data or both of them?
in meaning of performance?

byt the way the article to microsoft from the link u gave me is dead

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

harsh_athalye
Master Smack Fu Yak Hacker

5581 Posts

Posted - 2007-01-22 : 04:56:54

Why?
Don't you use filegroups in SQL 2005? or Partitioning supersedes it?

Harsh Athalye
India.
"The IMPOSSIBLE is often UNTRIED"

pelegk2
Aged Yak Warrior

723 Posts

Posted - 2007-01-22 : 05:19:03

i work on sql 2000

Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources