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 |
|
ebeworld
Starting Member
1 Post |
 Posted - 2009-04-16 : 13:44:25
|
| Hi,Our application has a huge Transation table and it is growing tremendously. Firstly, we have used table partitioning to speed up the process but now the size of the database is getting really big and we consider splitting the data into muliple computers. Is there any way to partition the database, yet they work as one database?Thanks,Ebe |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-04-16 : 14:08:58
|
| do you require all of these data? any chance of applying some archiving strategy to remove some of old & uninterested data? |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-04-18 : 00:28:49
|
| Table Partitioning is designed for this scenerio? Have you used it properly? Have you spreaded partitions accross drives and switched out old partition to archive locations ? |
|
|
|
|
|
|
Database partition over multiple computers