Results 1 to 10 of 10
  1. #1
    Join Date
    Dec 2008
    Posts
    1

    Unanswered: SQL Server - Reporting

    What is the best way to code a database to run reporting from. I am having trouble with running reports on anything greater than 1,000 record from SQL. I think it has to do with the way the database is set up and the security set up in the grouping of data. What are some of the best ways to code your databases so they run efficiently with little impact to the size of the records held?

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    I think the problem is probably with your code.
    1000 records doesn't even reach the level of "trivial".

    Post the query you are using to pull the data.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by sidbuser
    What are some of the best ways to code your databases so they run efficiently with little impact to the size of the records held?
    here are the two best ways: in and dexes
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Full of spit and vinegar today, aren't we Rudy?
    "letmegooglethatforyou.com". ha.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by blindman
    Full of spit and vinegar today, aren't we Rudy?
    "letmegooglethatforyou.com". ha.
    you should actually try that link, there's a cute little demo animation...

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Quote Originally Posted by r937
    you should actually try that link, there's a cute little demo animation...
    OK. How do I find the site?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  7. #7
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by blindman
    OK. How do I find the site?
    it's in this thread
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  8. #8
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    George
    Home | Blog

  9. #9
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Rudy's a little slow on the uptake today...
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    no, today i'm on da ball -- yesterday i was a bit tired, though
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •