• Jeff Moden (5/5/2012)


    The book title is "MCSE Training Guide / SQL Server 6.5 Design & Implementation. It was written to cover the old exam 70-27. It was published by New Riders Publishing and has a copyright of 1997. ISBN is 1-56205-830-4.

    Just FYI, it's available for $4-5 on both Amazon and eBay.

    My favorite paragraph in the whole books reads as follows (from the chapter on "Programmability")...

    "As a rule, SQL Server can minipulate an arbitrarily large set of data as a set faster than it can respond to an interative series of commands. Because most iterative solutions can be expressed as set operations with little work, cursors should generally be avoided. Thinking in terms of whole sets of data instead of individual rows is what makes the SQL language so different from other traditional programming languages. Looking for set-oriented solutions to problems is, however, an important transition to make."

    Now why am I not surprised that's your favorite paragraph?

    Thanks for sharing.

    Peter


    Peter MaloofServing Data