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 |
|
scottlucas58
Starting Member
8 Posts |
 Posted - 2009-01-21 : 14:19:51
|
| I have data from multiple sources and need to add to sql 2005.Essentially it is biz data from around the country. If i add what i have to a single table, it will be 20gig just to start. I will need to implement full text search on it. Is it better to break the data into 50 tables (one for each state) or keep it on one big table? I question partly because of ignorance of db maintenance and ignorance of fulltext search. Thanks in advance.-s |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-21 : 14:29:29
|
| You can use Table Partitioning feature(If Ent edition)for large tables.We don't use Full Text Search. |
 |
|
|
|
|
|
Opinions on handling large db