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 |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2008-02-23 : 16:20:48
|
| Guys,I am trying to make store all possible names from our clients in the database. The name search utility will run against this database. Is there any to partition the table across a disk in such a way that for names with Last Name starting from A to G is in disk M, H to M in disk N so on. And have index on the table partitions.Is this the effective to support 12 million distinct names in name search?Any suggestions about pros and cons of table partition and effective ways to index table partition would be helpfulThanks |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-02-23 : 17:37:33
|
| Table partition is supported only on SQL server 2005 enterprise edition.Not in SQL 2000. Yes you can with Lastname column partition. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-02-24 : 13:07:38
|
| Well you wouldn't want partitioned tables anyway as that's for historical/current data. What you want is partitioned views, which is available in SQL Server 2000 but perhaps only in enterprise. 12 million rows in a table is nothing. You don't need to partition yet.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Table Partition and Name Search