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 |
|
abcd
Yak Posting Veteran
92 Posts |
 Posted - 2008-11-24 : 01:17:41
|
| what are d various techniques to handle large database in sql |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-24 : 01:29:43
|
| what do you mean by handle? |
 |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-11-24 : 10:31:39
|
| If you mean optimise performance look into partitioning - both horizontal and vertical.Groups of tables can be moved onto seperate disk drives to increase disk through-put (vertical partitioning). You can also partition individual tables - useful for archiving older data i.e. partitions can be based on date. So only a portion of a table may only need searched in many cases. |
|
|
|
|
|
|
handling large database??