Transact SQL Practice Problems??
-
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
-
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
-
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] -
There are some interesting exercises at this site,
--------------------
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