I am creating partition function and schemes.
In SQL Server 2008, it only defines range partitioning and not list partitions.
Dont we have list partitioning in SQL Server?
I am using SQL Server 2008 Enterprise edition.
+2
A:
There is no List Partitioning in SQL Server 2008. But you can fake it into creating one using the LEFT clause.
Read up here:
Raj More
2009-10-23 22:03:01
What about hash partition?
Manjot
2009-10-23 22:09:37
AFAIK Hash Partitioning is not implemented in SQL 2008.
Raj More
2009-10-23 22:33:49
It was originally planned (syntax for it existed in the early betas) but it was dropped halfway through the beta period. Wish I could share details on why.
Aaron Bertrand
2009-10-23 23:39:01
Thank you very much
Manjot
2009-10-25 00:17:37