Post reply

Transact SQL Practice Problems??

  • January 18, 2005 at 8:45 am

    #74842

    Has anyone ever come across a resource that is comprised of T-SQL practice problems and solutions using pubs and northwind databases (or something similar)?

    I am very interested in improving my use of table self joins, flow control language , optimal relational DML  etc.  I tend to overuse in-line queries (which frequenty introduces system limitations), piggybacking of views, and temp tables.

    I've decided these are bad habits...

    If anyone has run across a great "workbook" or problems manual for developers, I would love to know about it.

    TIA

    Ryan

  • January 18, 2005 at 8:56 am

    #537858

    One resource often underestimated, or just plain overseen is the system procs already on the server. They may not be all estethically perfect, but provides some good reading nonetheless.

    /Kenneth

  • January 18, 2005 at 1:03 pm

    #537911

    Well, actually no workbook, but one of the best resources are the Google Groups Archives. Several MVP's have the nice habit to demonstrate good and efficient techniques using the sample databases for their postings. The only disadvantage is that you need to know what to search for. I have identified my handful of favorites and download only their postings and analyze them carefully. And no, I won't mention *any* name here.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • January 19, 2005 at 3:30 pm

    #538192

    There are some interesting exercises at this site,

    http://www.sql-ex.ru/?Lang=1

    --------------------
    Colt 45 - the original point and click interface

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

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