Nuacht

Learn how to use, test, measure, and optimize different hash algorithms in SQL Server with T-SQL stored procedures.
Learn about the advantages and disadvantages of hash-based and range-based sharding keys, and how to choose and optimize them for your data engineering needs.
Combining hash-sharding and regional by row locality should mostly work already, especially after #94436. For example, this works: CREATETABLEab ( region crdb_internal_region NOT NULL, a INTNOT NULL, ...