Category: Intermediate

New Hotness: sys.objects and sys.schemas

Last month we talked about the old and busted syscomments– and the new hotness that is sys.sql_modules – for pulling code out of your database using T-SQL.  I’m finally transitioning over to sql_modules for good, even though I’d been a slow adopter.  This month, though, I’m already in SQLlove with the new hotness: sys.objects. The old sysobjects […]

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 […]