TURBU Tech – The last few versions of MS SQL Server have included a feature where you can create new functions in .NET assemblies and register them with the database server. This can be a good way to deal with concepts that are difficult to express in T/SQL, and it can provide some big performance boosts. The process is not without its warts, though. A few weeks ago, I found that the query for a major report in our system at work was spending a huge amount of time in the CPU, not the database itself. Turns out we had some data that was encoded as a variable-length string, and a T/SQL function that ...
Visits by Source
Users who voted for this posting