Post reply

Looking for a good Database Design guide

  • October 11, 2006 at 9:18 am

    #169979

    Hello all,

    I've recently upgraded a couple of our databases from SQL2K to SQL2K5.  Nothing special just a basic normalized database that could have been implemented in SQL7.  These are small databases BTW, only about 1GB in size if that.  Well after playing around with SSMS, I have to say WOW, this is too cool.  Playing with the demo databases from MS, I noticed this new schema thing and new T-SQL terms that I would love to learn more about.

    I see in some areas where our current database could benefit from these new features but from the looks of it, I may have to start over.  So my question is, Are there any good beginner or intermediate guides on how to design an effective SQL 2K5 database?

    Any links or help would be greatly appreciated.

    Thanks,

    Brian

  • October 11, 2006 at 10:05 pm

    #665361

    Books Online... comes free qith SQL Server... lookup "Database Design" (I think)...

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

  • October 16, 2006 at 3:25 pm

    #666082

    I think you need a good book, the second book in the second link Data Modeling by G.Lawrence Sanders is very good, old but still in first print, the last link is free data models you can clone for your use.  Hope this helps.

    http://www.utexas.edu/its/windows/database/datamodeling/rm/rm7.html

    http://www.databaseanswers.com/modelling_books.htm

    http://www.databaseanswers.org/data_models/index.htm

     

    Kind regards,
    Gift Peddie

  • October 17, 2006 at 7:30 am

    #666200

    Superb Gift,

    Thank you very much, its a very good start in the right direction.

    Again, thx.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply