March 22, 2004 at 3:10 pm
Hi..
I'm a new DBA to SQL Server. I have three tables that is "larger" than the rest about a 1 million+ rows each and expect to grow greatly. Would it benfit me to move the three tables into seperate data file? If so, how would I move them?
Thanks for any input....
March 22, 2004 at 7:12 pm
It can help sometimes especially if you can move to different array drives from the main one. The key is where the clustered index is stored, you have to create another file attached to the DB with a different group name other than Primary. Then either use EM to move (easier to do) or do an ALTER to change the location of the clustered index or table if heap (no clustered index).
March 23, 2004 at 2:39 pm
Ok.. Thanks for the information. I hate to ask such a dumb question, but I still don't know enough... How do I determine what the current clustered indexes?
March 23, 2004 at 3:08 pm
The easiest way is to open EM, drill down to your table, right click and choose "Design Table", then on any whitespace area and right click, choose Index/Keys and there you can see the settings of the indexes and make adjustments. Or In EM right click the table, under All Task choose Manage Indexes which also will give you an overview.
March 24, 2004 at 6:24 am
Thanks.... I'll move them....
March 25, 2004 at 12:07 am
To find out indexes on a table, it would be easy to run the T-SQL satement from Query Analyser
sp_helpindex <table_name>
eg: sp_helpindex syscolumns ---> will list all the indexes on the table syscolumns. The index description in the result give details of the index like clustered, nonclustered etc
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply