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 |
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
 Posted - 2006-12-18 : 05:02:31
|
| Hi,I'm working on an application that is going to have one pretty giant table with consistent growth. The table will have 7-8 columns totalling only 60-100 bytes each row. It's a logging table and I have to design for eventually handling 50 million rows and could go alot higher.I am considering starting it on a SQL2000 box at the beginning as we already have one, however I am also considering a new SQL2005 box for it as well. My question is, does SQL2005 have any new features that would help with working with tables this large? I have read something about it supporting some forms of table partitioning but this is all new to me.I have zero experience with table partitioning.Any general tips to help me in the design of this table are greatly appreciated. Thanks very muchmike123 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-18 : 05:34:02
|
| Here is an Excellent white paper written by Kimberly Tripp on the topic:[url]http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm[/url]Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
mike123
Master Smack Fu Yak Hacker
1462 Posts |
Posted - 2006-12-19 : 03:57:14
|
| definatley lots to digest there :) thanks for the link!looks like sql2005 is the way to go for sure once I have the need for table partitioning:)thx! |
|
|
|
|
|
|
working with large table