• Pick a column in your table and create a persisted computed column off it using the HASHBYTES function:

    ALTER TABLE dbo.[TableName]

    ADD [HashedColumnName] AS CAST(HASHBYTES('MD5',CAST([ExistingColumnName] AS VARCHAR(40))) AS VARBINARY(40))

    PERSISTED -- important, computed column must be persisted to be used a partition column

    Creating Partitioned Tables and Indexes

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato