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 |
|
Ghanta
Yak Posting Veteran
96 Posts |
 Posted - 2007-12-22 : 19:50:28
|
| Hey Guys,I have 10 tables of Individuals info (id, street address, city, state, ...) broken down by starting digit of Zipcode... 0..9. I need to break these 10 tables into 50 tables 1 for each state ... Each state will have its own table... What is the best way to do this?Thanks a lot for your time and assistance. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-22 : 21:19:41
|
| Create 40 more tables then move data with 'inster into ... select * from ... where state = ...'. |
 |
|
|
Jeff Moden
Aged Yak Warrior
652 Posts |
Posted - 2007-12-23 : 11:27:04
|
| Like I said on the "other" forum, you'r eopening yourself up to a real world of hurt... unless you happen to make a partitioned view, as well.--Jeff Moden |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-23 : 16:54:57
|
| Depends, I use similar way to solve blocking issue on very heavy oltp system. |
|
|
|
|
|
|
Breaking Down Tables into several Smaller Tables