Bob Ward is a Principal Architect for the Microsoft Azure Data team, which owns the development for Microsoft SQL ground to cloud to fabric. Bob has worked for Microsoft for 31+ years on every version ...

In SQL Server 2016, this feature is vastly improved, supporting foreign keys, check and unique constraints and parallelism. Additionally, tables up to 2TB are now supported (up from 256GB).

After confirming with the SQL Server DBA that a CLR function would be permitted on the production SQL Server, I wrote the function that appears in Listing 1. You'll notice it uses the Microsoft.Net ...