February 2007 Entries
I've started investigating the SQL CLR and decided as my first article to tie in a bit to my article on using SQL parameters in ad hoc queries. This time I'm touching on an advanced topic of sql parameters - how to pass an array as a parameter. This takes advantage of the performance benefit you get from parameters because the plan can be cached for queries that use dynamic IN statements.http://www.codeproject.com/cs/database/TableValuedFnsAsArrays.aspNext, I plan on writing a series of articles on the SQL CLR discussing the following topics:CLR SecurityCLR Performance/StabilityCLR vs T-SQLCLR Best PracticesI've almost finished the first article on...