dcsimg
Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2006
    Location
    Portland, Oregon
    Posts
    64

    Question Feedback on Part 15: The Cost of Distribution

    [This thread is associated with Part 15 of the SqlCredit series.]

    Please add your thoughts or comments on the tests or the results.

    How did your expectations line up with the results?
    Last edited by rgarrison; 04-25-2008 at 10:49 AM. Reason: Article is now published

  2. #2
    Join Date
    Jul 2003
    Location
    Netherlands
    Posts
    3
    I thought it could be about the same (because data has to be looked up in both cases) or probably 2 times as long (if the case with foreign keys is more favorable because Sql Server knows there are matches in the joined tables for each purchase).
    It is obvious the data will always be looked up with a simple queryplan through the primary keys.
    At first I wasn't aware that every record would be read several times.
    I don't know if keeping the data in memory is more favorable in one layout than in another layout.

  3. #3
    Join Date
    Jun 2006
    Posts
    4
    It's a pitty you didn't compare db-distribution to file distribution.
    Especialy since with sql2005 you can also use partitioning, even put parts of your table in read-only mode, ...
    And because of the way "schema" is promoted for usage, you can even consolidate different dbs providing way better "dbo" functionality via schema authority.

Posting Permissions

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