Yep – there’s a Part 3 to this Closer Look at SELECTs series. Who knew there was this much to say about the SELECT statement?
(If you missed Part 1 and Part 2, check them out!)
By looking at SELECT statement, you can tell a lot about your database design before looking at a data model or checking system tables or executing any of the sp_help* stored procs. You’ll want to consult any and all of those to help you along the way but the SELECT statements can help give clues about what you will find or what you should find.
Deb the DBA 