SQL Server Performance

User Defined Functions

Discussion in 'Performance Tuning for DBAs' started by Chappy, Jan 6, 2003.

  1. Chappy New Member

    One of our developers is adding a lot of UDF's (some of them complex), and then referencing them in select lists. Others are very simple which IMO would be better done inline in the sql.

    Are there any resources which explain how sql server handles UDF's ?
  2. satya Moderator

  3. bradmcgehee New Member

    There is a good section on this topic on pages 617-628 of Inside Microsoft SQL Server 2000 by Kalen Delaney.


    ------------------
    Brad M. McGehee
    Webmaster
    SQL-Server-Performance.Com
  4. Chappy New Member

    Thanks Brad. This is very useful!

Share This Page