How to do this...?

• Rudyx - the Doctor

  SSC-Forever

  Points: 43695

  More actions

  December 17, 2009 at 1:42 pm

  #1093747

  Just about everything mentioned as a solution will work towards your end in some fashion. However, this will not remove the fact that there is a basic architectural issue with the system. A database or database 'tweaking' alone cannot solve the issue. It seems that a mixture of application, database and BI is what the doctor should order. If the system and the business revenue that it generates are that critical to the bottom line then justification on spending a few bucks on a good consultant with heavy business/applications analysis seems like the right thing to do.

  RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

• Jeff Moden

  SSC Guru

  Points: 1004363

  More actions

  December 17, 2009 at 7:16 pm

  #1093846

  krypto69 (12/15/2009)

  ---

  I don't really have access to the individual transactions. I know that sounds odd, but this is a core system for us, they do not want it tampered with directly.

  So, I was hoping to use snapshots for them to hit against, for the historical data they need. And actually it would only be one or two people that would need to access the snapshot data and report off of.

  So..... ask them to make a snapshot to report off of.

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