Category: sql server

Journal: SQL Saturday #52

Friday 6am – up to catch an 8:30 flight. My daughter Lisette is going with me on this trip. 9:30am local time, we arrive in CO. Grab a car and head north to Fort Collins for Beau Jo’s pizza, free loaner bikes from the Bicycle Library, and general sightseeing. BEAUTIFUL flower garden on the university […]

SELECT: If ON preceeds JOIN, then how….

I got some excellent questions from my 24HOP session yesterday, and when presenting the same session at NTSSUG last night.  There were a few questions pointing to the same area:  * How is the ON clause evaluated before the JOIN clause?  * If ON is evaluated before the JOIN, how does it resolve table aliases […]

24HOP Session: Forgotten T-SQL

Here, just in case you don’t want to read all my rambling: Download the Forgotten T-SQL session code here.  Edit (10/1/2010): The 24 Hours of PASS Fall session recordings are up!  You’ll need to use your PASS login, or register, to access the recordings. Session Wrapup Speakers always say “thanks for coming” and “I really appreciate […]