Category: SQLPASS

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

T-8d till SQL Saturday #52 (CO)

Post author By Jen McCown
Post date September 17, 2010
Categories In SQL Saturday, SQLPASS, sqlserverpedia-syndication, SSC

It’s only twelve eight days until SQL Saturday #52 in Colorado! I’ll be presenting Code Sins and my new T-SQL Brush-up. Check out the schedule…you have sessions from such awesome and familiar names as Chris Shaw, Drew Minkin, Glenn Berry, Jack Corbett, Janis riffin, Jason Strate, Meredith Ryan-Smith, Steve Jones, Tim Mitchell, and oh so many more… […]

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