Vote UpVote

When is a null not a null?

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 ...
Favorite? Off-Topic? Mason Wheeler @ 2010-10-07 03:37


Visits: 671
Votes: 4
Favorites: 0
Off-Topic: 1

Visits by Source

User Actions

Users who voted for this posting

Charles Ardour
Contact us to advertise on DelphiFeeds.com

Community Links

Torry Firebird News


Please login or register to use this functionality.
(click on this box to dismiss)