Partition Function - SQL Server Forums

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Partition Function

Author

Topic

scelamko
Constraint Violating Yak Guru

309 Posts

Posted - 2008-02-25 : 15:02:31

Guys,

I have names in the database which I want partition by last name - for example last names starting with A, B, C, D should go to the file group 1. last names starting with E, F, G, H should go to file group 2.

I am trying to use the following function - but do I specify in the function that last names with with A, B, C, D should go to the file group 1

CREATE PARTITION FUNCTION myRangePF3 (char(20))
AS RANGE RIGHT FOR VALUES ('EX', 'RXE', 'XR');

Is there any way to modify partition function to accomplish this?

Any suggestions and inputs would help

Thanks

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-02-25 : 15:28:02

[code]ALTER PARTITION FUNCTION partition_function_name()
{
SPLIT RANGE ( boundary_value )
| MERGE RANGE ( boundary_value )
} [ ; ][/code]

E 12°55'05.25"
N 56°04'39.16"

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-02-25 : 15:42:30

You should have SQL 2005 enterprise edition for partitioning.

Here you go:

CREATE PARTITION FUNCTION myRangePF3 (char(20))
AS RANGE RIGHT FOR VALUES ('A-D', 'E-h', 'H-Z')

and create partition Scheme and put different partition in different FG and in different disk.

cybertron
Starting Member

4 Posts

Posted - 2008-02-26 : 03:54:08

I've implemented sql server partition table. What if i don't have more this ? - Only one disk-, Can i put it on one disk ? because the performance is ok despite only one disk. Any other good idea ?

"We give you that we know, We share to you that we've learned, We send to you that we need to be discussed"
http://cybertron-network.blogspot.com

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-02-26 : 21:53:22

You can put all partitons on single disk. How big the table is? Really need partition?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources