4
votes
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

Statistics

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

Visits by Source

User Actions

Users who voted for this posting

Barton_Stano
Charles Ardour
stukelly
Tier777
Subscribe:
Contact us to advertise on DelphiFeeds.com

Community Links

Torry Firebird News

Sponsor

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