Poor performing query on

• Jeff Moden

  SSC Guru

  Points: 1004591

  More actions

  July 9, 2013 at 10:39 pm

  #1631060

  First, thanks a bunch for the updates on this. We're getting close to doing the same thing (update) and this will help with some of the things to watch for

  richard.austin (7/9/2013)

  ---

  I turned the trace flag off and the query now[font="Arial Black"] runs in seconds[/font], all be it [font="Arial Black"]with a sub optimal plan[/font].

  BWAAA-HAAA!!!! Considering what you just went through, I'm thinking that the sub optimal plan isn't so bad.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)