SQL Server Performance

Search Results

Search Again
  1. Jackson1111

    User Defined Function Causing Performance Issue

    Thread by: Jackson1111, Aug 11, 2009, 1 replies, in forum: SQL Server 2005 General DBA Questions
    Hi All, Below query having UDF(user defined functions) which is causing performance issue , how to optimize it?? SELECT @US_MKT_CD =...
  2. Jackson1111

    Query Consuming Time

    Thread by: Jackson1111, Aug 10, 2009, 2 replies, in forum: SQL Server 2005 Performance Tuning for DBAs
    Hi All, The below query is consuming time , please provide inputs to optimize RETURN ( SELECT TOP {##} CASE WHEN @TYPE = {STR} THEN...
Showing results 1 to 2 of 2
Search Again