SQL Server Performance

What is the best reporting technique?

Discussion in 'SQL Server 2008 General Developer Questions' started by tarekj, Jun 26, 2011.

  1. tarekj Member

    What is the best reporting technique should I use with crystal reports and SQL server to get the best reporting performance?
    - use SPs?
    - summary information should be summarized in the SP first or summarized in the Crystal report?
    - if I want to do some calculations, should I use any temp database in the client machine? (access db for example)? or I may use the SQL server temp db?
    - can I easily isolate the temp db per user?
    - does the temp db increase the log file?

    Thanks
  2. satya Moderator

  3. mmarovic Active Member

    Use sp, but make cristal report do summarization.

Share This Page