Sql Server 2017 Hash partition

Question

Hello, I have a question please.

Using Sql server 2017 version, I try to create partitions in a table, so I would know, can I use Hash partition?

For exemple, this is a function partition use Int :

create partition function PartitionFunctionByInt (int) as range LEFT for values (0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40)

How can I adopt this with Hash please?

Thank you for helping.

Answer 1

There's only range partitioning in SQL Server.

When SQL Server 2005 was in beta, we had hash partitioning, but that didn't make it to the released product. And it wasn't introduced in later versions either.

Answer 2

You can still roll your own hash partitioning. That is, your partition key could be a "hash" of some data that places data more or less randomly in any of these 36 buckets. But you would have to have quite a specialised use case for this to make sense.