T-SQL - create partition function and scheme - SQL Server 2008

Question

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.

Raj More · Accepted Answer · 2009-10-23 22:03:01Z

3

There is no List Partitioning in SQL Server 2008. But you can fake it into creating one using the LEFT clause.

Read up here:

http://www.sqlservercentral.com/articles/partition/64740/

answered Oct 23, 2009 at 22:03

Raj More

48.2k34 gold badges139 silver badges199 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Raj More Over a year ago

AFAIK Hash Partitioning is not implemented in SQL 2008.

Aaron Bertrand Over a year ago

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.

Collectives™ on Stack Overflow

T-SQL - create partition function and scheme - SQL Server 2008

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related