Results 1 to 7 of 7
  1. #1
    Join Date
    May 2011
    Posts
    11

    Question Unanswered: Optimization Links/Articles/Books

    Hi everyone,

    I`m Looking for newbie articles about optimization,
    at software level of the SQL ( By this i mean making the database run faster without having to upgrade the machine itself)
    i have found myself quite plenty of material,
    but i was wondering that someone here could point me a way into easy readable material, since lots of the material i've found require a certain knowledge of the subject.
    any reference is welcome, articles, books, threads in the forum and so on.
    thanks

    i'n a newcomer to the forum so sorry if this goes against any policies of this forum
    Thanks in advance

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Basically indexing. That's the first thing you want to look into.
    If it's not practically useful, then it's practically useless.

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

  3. #3
    Join Date
    May 2011
    Posts
    11
    Blidman i wish you could read my post thanking you !

    any book/article you would recommend yourself?

    EDIT : i do know how to google but people who actually work with it tend to know way better where to look, and what is worth the work.
    thanks

  4. #4
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Other things you should look for are unnecessary cursors instead of set-based processing, and non-sargable sql queries (often filtering on an approximate date value).
    If it's not practically useful, then it's practically useless.

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

  5. #5
    Join Date
    May 2011
    Location
    Boston, MA area
    Posts
    4

    Joins instead of subqueries

    Hi,

    Another suggestion for SQL Server is to avoid the use of subqueries and to instead use joins. SQL Server is much better at caching the execution plan for join-based queries than subqueries.

    I recently did a comparison of joins vs. subqueries here: Efficiency of Subqueries and OR conditions in SQL | Explore SQL Database Query Development.

    A separate but important point is to avoid using "select * ..." in queries as, by doing that, you're likely bringing back much more data to the caller than is really needed [and this can have a definitive speed impact depending on the number of times the query is called and the throughput of the network over which the data is being returned].

    I hope this helps.

    - Andrew Zwicker. Visit Help With SQL: Explore SQL Database Query Development

  6. #6
    Join Date
    Jul 2011
    Posts
    9

    Optimization Basics

    Hi,

    This site has a lot of good articles that help with optimization. The articles are in an easy to read format for someone new to optimizing queries.

    SQL Optimizations School

    Jason
    Last edited by Jason W.; 07-03-11 at 16:36.

  7. #7
    Join Date
    Mar 2007
    Location
    Holmestrand, Norway
    Posts
    332
    Not a beginners book, but perhaps one of the best books written related to performance optimzation? Dissecting SQL Server Execution Plans
    Ole Kristian Velstadbråten Bangås - Virinco - MSSQL.no - Facebook - Twitter

Tags for this Thread

Posting Permissions

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