Sql Server 2005 Partitioning

[sendba]

All
I am trying to partition a 900 Million record table.
All the columns in this table is Varchar
I am using the following statement to create the function.

create partition function pt_fn_fnname(varchar(12))
as range LEFT for values ('100000000' ,'200000000', '300000000','400000000', '500000000' , '600000000', '700000000', '800000000' ,'900000000',
'1000000000')

I get the following warning

Warning: Range value list for partition function 'pt_fn_fnname' is not sorted by value. Mapping of partitions to filegroups during CREATE PARTITION SCHEME will use the sorted boundary values if the function 'pt_fn_cardcellular' is referenced in CREATE PARTITION SCHEME.

My question is whether this will have any performance impact. and also what is the best solution

Please advice.

Thanks

Sen

 

[SQLBI]

I think this maybe due to the ordering of the partition boundaries as when sorted, '1000000000' will occur before '200000000', yet you have it as you last partition boundary.

Do you still get the error if you do?:

create partition function pt_fn_fnname(varchar(12))
as range LEFT for values ('100000000', [b]'1000000000'[/b], '200000000', '300000000','400000000', '500000000' , '600000000', '700000000', '800000000' ,'900000000')

Cheers,
Leigh

"If you had one shot, one opportunity, to seize everything you ever wanted, in one moment, would you capture it, or let it slip" - Eminem

 

[sendba]

Thanks