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 |
|
Bill_C
Constraint Violating Yak Guru
299 Posts |
 Posted - 2009-10-01 : 02:44:20
|
| Can anyone advise me as to when I should be looking at partitioning tables?Currently some of our tables vary between 5GB and 65GB in size, should I be looking at partitioning these to improve performance?The database they reside in is around 130GB, should this also be split/partitioned?Thanks for any guidance as I've never done this before. |
|
|
winterh
Posting Yak Master
127 Posts |
Posted - 2009-10-01 : 08:42:57
|
| Tables can be any size as long as you index properly.[ /fail at query] |
 |
|
|
winterh
Posting Yak Master
127 Posts |
Posted - 2009-10-01 : 08:44:15
|
| Tables can be any size (And shouldn't affect performance) as long as you index properly. What type of indexes are you using on your columns?[ /fail at query] |
|
|
|
|
|
|
Advice please on max table size.