Category: Tech and Learning

SELECT: If ON preceeds JOIN, then how….

Post author By Jen McCown
Post date September 17, 2010
Categories In 24HOP, Beginner, Intermediate, NTSSUG, sql server, SQLPASS, sqlserverpedia-syndication, SSC, Tips, TSQL
3 Comments on 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

Post author By Jen McCown
Post date September 16, 2010
Categories In 24HOP, 24HOP, Beginner, Intermediate, Level, News-ish, SQL Saturday, SQLPASS, Tips, TSQL
3 Comments on 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 […]

New Hotness: sys.sql_modules

Post author By Jen McCown
Post date September 15, 2010
Categories In sql server, sqlserverpedia-syndication, SSC, Tips, TSQL
1 Comment on New Hotness: sys.sql_modules

I’m still old school in many ways. And they’re not the ways that let you get away with wearing wayfarers, or shouting “get off my lawn, you kids!” In this case, I’m still havin a hard time weaning myself off the old system table “syscomments”. I LOVE syscomments…I can find a piece of code anywhere in […]