PatExclude8K

• Jeff Moden

  SSC Guru

  Points: 1003863

  More actions

  March 17, 2019 at 5:18 pm

  #2024740

  I never actually trust the % of Batch stuff to make actual decisions about performance.  I've also never seen a performance test on the use of the TEXT() function v.s. just the "dot".  Anyone know of such a performance test?

  --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)
  

• Eirikur Eiriksson

  SSC Guru

  Points: 182882

  More actions

  March 18, 2019 at 7:34 am

  #2024758

  Jeff Moden - Sunday, March 17, 2019 5:18 PM

  I never actually trust the % of Batch stuff to make actual decisions about performance.  I've also never seen a performance test on the use of the TEXT() function v.s. just the "dot".  Anyone know of such a performance test?

  I'll dig out some, done quite few in the passed 😉
  😎