How To Write Better SQL Queries

How To Write Better SQL Queries

Howto, Technology
[powerpress]http://www.darrentaff.com/wp-content/uploads/2014/07/How-To-Write-Better-SQL-Queries.m4a[/powerpress] In this audio session we talk about how strategic query formation can help you get exactly the information you're looking for with a minimal amount of work Here's a video of the technique I describe in the recording http://www.youtube.com/watch?v=OFDMUdj0xCg Key points from this lesson: Start with the end in mind Alias the tables Let SSMS do the heavy lifting Start With The End In Mind What is the main body of information we wish to find?  Where does that information live in the database?  This is the table we're going to query first.  All other data we use to enhance the dataset will appear in the form of joins, subqueries, and all the usual suspects.  Starting with the FROM portion of the query will get things set up so…
Read More