My previous post showed a simple test that appears to suggest that you may experience significant performance degradation if multiple users are calling the same SQLCLR function at the same time and they are all catching a lot of exceptions.   However, it’s not clear whether that behavior is limited to SQLCLR or applies to .NET in general. ...

If you have many try/catch blocks in your .NET code and your code execution actually passes through them, you should expect a performance hit. That’s intuitive and no surprise.   What is surprising is the extent to which you may experience severe performance degradation when multiple users are executing a piece of SQLCLR code (e.g. calling ...

Fall is now in full swing, and after a relatively quiet several months my speaking schedule is about to jump into fairly-packed mode.  Following is a list of where I'll be headed over the next couple of months: Next week I'm really excited to be teaching a day of the Microsoft Certified Master: Microsoft SQL server 2008 program's beta ...