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 |
|
lazerath
Constraint Violating Yak Guru
343 Posts |
 Posted - 2008-11-21 : 15:57:45
|
| SQL Server 2005 Standard edition does not come with the "Enterprise" table partitioning features and yet I am interested in finding another way to save time and energy over manually partitioning each table I need this done for.Are there any third party products or open source tools that would help? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-21 : 18:17:55
|
| Then you should consider using Partition Views in SQL 2005 SE. |
 |
|
|
lazerath
Constraint Violating Yak Guru
343 Posts |
Posted - 2008-11-21 : 18:44:26
|
| According to this link:[url]http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx?PHPSESSID=0324345d45ef1bf1f764044e03584cd0][/url]The only edition that supports partitioning is Enterprise Edition (EE).As a note, googling "sql server partition without enterprise" has returned some interesting results:[url]http://sqldev.wordpress.com/2008/03/16/sql-server-table-partitioning-without-enterprise-edition/[/url]and[url]http://www.donwellsoft.com[/url]I will continue to research the topic, but please continue to post any relevant information. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-11-21 : 19:00:24
|
http://weblogs.sqlteam.com/peterl/archive/2007/09/24/Horizontal-partitioning.aspx
E 12°55'05.63"N 56°04'39.26" |
|
|
|
lazerath
Constraint Violating Yak Guru
343 Posts |
Posted - 2008-11-21 : 21:14:01
|
| I understand horizontal partitioning but I am seeking a way to "automate" partitioning without using Enterprise Edition. Using the magic of Horizontal Partitioning, it should be possible to use a template generator in combination with triggers, jobs and/or the service broker to essentially manage the implementation.As a note, the SQL Partition Manager I linked to does not offer any assistance with regard to this problem - it requires SQL Server Enterprise. |
|
|
|
|
|
|
Automatically Partitioning in 2005 Standard?