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 |
|
satishk
Starting Member
39 Posts |
 Posted - 2007-04-24 : 10:40:37
|
| Hi,I have a database created using Enterprise Manager Wizard.For example datafile db1_data.mdf and log file db1_log file exists.All the tables are created in datafile db1_data.mdf.Now to improve performance I want to implement table partitioning.Can anybody tell me howto implement it with existing strutcure.Suppose there is table Mytable in which all update and delete actions are performed regularly.And it contains about 10,0000 records.I want to partition the table so that it contains 5000 records.Solution with example highly appreciated.Satish |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-24 : 12:09:47
|
| This is discussed in quite a bit of detail in SQL Server Books Online. Did you have a specific question, perhaps something you didn't understand in BOL?Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-24 : 12:45:52
|
| You have to recreate the table, that's for sure. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-04-24 : 14:04:32
|
10000 records is cake. seems to me a table that small does not require partitioning.
www.elsasoft.org |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-24 : 14:07:05
|
| Agreed.We are considering partitioning on a system that will be inserting 40-120 rows per second. Luckily the 40-120 rows per second is in the future, so it gives us time to work on the design.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-04-24 : 17:41:44
|
Is that data for me Tara? 
www.elsasoft.org |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-04-24 : 18:01:23
|
| Yes! I've got lots of ideas for that system. I'm pretty sure that we will implement partitioned views rather than partitioned tables.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-04-24 : 18:48:37
|
excellent, can't wait to start crunching it.  all day today I've been importing a 1.3 billion row dataset. things take longer when you work at that scale!
www.elsasoft.org |
|
|
|
|
|
|
Table partitioning