Author |
Topic |
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2008-04-08 : 17:41:21
|
dos in SQL2005 exist the possiblity to use "PARATITION" like in mysql 5.1==> [url]http://dev.mysql.com/doc/refman/5.1/en/partitioning-overview.html[/url]thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-08 : 17:45:43
|
Didn't get your question clearly? Yes, SQL server 2005 has table partition which is only supported in Enterprise edition. |
|
|
nr
SQLTeam MVY
12543 Posts |
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2008-04-08 : 18:19:32
|
thnaks for the article!but i didnt understand what execlly does the left/right in the paratition means?for example:CREATE PARTITION FUNCTION MyPartitionRange (datetime) AS RANGE RIGHT FOR VALUES ('20070101', '20070201', '20070301', '20070401') what/hoe does the right command Influence on the creation of the paratition?thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-08 : 18:29:32
|
For LEFT1st partition is all data <= ‘20070101’2nd partition is all data > ‘20070101’For RIGHT1st partition is all data < ‘20070101’2nd partition is all data => ‘20070101’Check out Microsoft White paper and test it:http://www.sqlskills.com/resources/Whitepapers/Partitioning%20in%20SQL%20Server%202005%20Beta%20II.htm |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2008-05-26 : 09:38:11
|
few questions about paration's :1)if i already have a table - do i need to delete it to build it with paratition's?if not what do i need to do so it will support paratitioning?2)i want to build paratitions in ranges for each date, for example :20080526000000 to 20080526235959 (day)20080527000000 to 20080527235959 (day)and so on.........how can i create this paration's dynamicly,and how do i delete old paratitions?thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-05-26 : 09:44:31
|
http://www.databasejournal.com/features/mssql/article.php/3643726 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-26 : 10:02:27
|
1)No2) Did you see the white paper ?3) See whitepaper for Partitioning for Switch out. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-05-26 : 10:22:33
|
There is alter partition function too. E 12°55'05.25"N 56°04'39.16" |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2008-05-26 : 12:07:49
|
any one know's what does this means : quote: ALTER PARTITION SCHEME MyPartitionScheme NEXT USED [PRIMARY]
thnaks in advancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-26 : 20:48:03
|
Specify filegroup. Does books online tell you that? |
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2008-05-27 : 04:09:42
|
the reason that i ask about it, its beacuse when i tried to chaghe the paratition few times i must use :ALTER PARTITION SCHEME MyPartitionScheme NEXT USED [PRIMARY]else i am getting this error :quote: Msg 7707 :The associated partition function 'MyPartitionRange' generates more partitions than there are file groups mentioned in the scheme 'MyPartitionScheme'.
and the solution was to do :ALTER PARTITION SCHEME MyPartitionScheme NEXT USED [PRIMARY]ALTER PARTITION FUNCTION MyPartitionRange () split RANGE (10)ALTER PARTITION SCHEME MyPartitionScheme NEXT USED [PRIMARY]ALTER PARTITION FUNCTION MyPartitionRange () split RANGE (12)Israel -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|