Category: Beginner

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

Brief Intro to Indexes and INCLUDE – TSQL Tuesday #10!

Post author By Jen McCown
Post date September 14, 2010
Categories In Beginner, sql server, sqlserverpedia-syndication, SSC, TSQL
4 Comments on Brief Intro to Indexes and INCLUDE – TSQL Tuesday #10!

Content rating: Beginner This blog was originally posted on December 17, 2009. I’ve pulled it out of the closet for T-SQL Tuesday #10, with apologies for being too gosh-darn busy to write something new. This is a companion blog to “Get Index Included Column Info“. What are indexes for? We need to talk indexes […]