N S

Novick Software Management • Design • Programming • Training • Consulting

   

 

 

Originally presented to New England SQL Server Users Group, January 2003, it's been updated to reflect for the presentation to the New Hampshire SQL Server Users Group in February 2004.

This is an introduction to SQL Server 2000 User-Defined Functions.  It covers:

  • How to create and use the three types of UDFs: scalar, inline and multistatement.  
  • Performance issues are a major part of the discussion.  They can be a problem with a UDF. 
  • Permissions to use UDFs are discussed
  • Additional topics such as  debugging,
  • The system UDFs are discussed:

    fn_virtualfilestats
    fn_trace_*
    fn_get_sql
    and more....

 

You may download the User-Defined Functions Slides  or Download sample database and script of User-Defined Function presentation.

 


RSS as HTML

Personal Blog

 
New Tips:

Loading SQL Profiler trace (.trc) files with fn_trace_gettrace

Upcoming
Presentations:

Defending
SQL Server
from SQL
Injection Attacks

July 8, 2009
RI SQL Server


Full Schedule