Microsoft’s SQL Server may be a big dog in the enterprise database market, but its conspicuous lack of user-defined functions (UDFs) has stacked up poorly against other leaders of that pack.

The classification function is a user-defined function (UDF) written in good ol’ Transact-SQL whose logic enables Resource Governor to classify sessions into the existing workload groups defined in ...