SQL Server Performance

Where and when to use userdefined functions (scalar)

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by w84me2say, Oct 26, 2007.

  1. w84me2say New Member

    I have a few developers working on creating functions.
    What are the best practices on when and where to use them.
    Can you use it in the From, Where, Select clause or are there places you shouldn't use function?
    One of the developers mentioned that they had created a function, but was using it in the wrong place and it caused a performance hit.
    Thanks in advance for your help
  2. MohammedU New Member

Share This Page