1. There is an inherent overhead in calling CLR functions Not so. Try creating a T-SQL function and a CLR function that both do absolutely nothing other than return the value 0. When called in a loop, you will find that the CLR function executes substantially...

What started as another blog post turned into an official SQL Server White Paper. If you are interested, you can find it here .

Every once in a while, a process gets too complex for humans to manage consistently. For example, when Boeing’s B-17 (the “flying fortress”) was first being evaluated, it crashed during initial tests due to pilot error. The consensus became that it “was...