Category: sqlserverpedia-syndication

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

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