SQL Server Performance

Any known performance issues with Pivot?

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by bhushank21, Jun 6, 2007.

  1. bhushank21 New Member

    SQL 2005 introduced PIVOT for cross tab reports.
    Are there any known performance issues of using the PIVOT keyword?
    Or is it better to do the cross tab formatting in the UI instead of SQL?

    Thanks and Regards,
    Bhushan
    http://www.metacafe.com/watch/365213/wonder_what_you_are
  2. Madhivanan Moderator

    If UI supports Cross tab then do it there
    But anyway you need to compare the time taken at server and client sides

    Madhivanan

    Failing to plan is Planning to fail

Share This Page