Category: Beginner

Forgotten T-SQL Cheat Sheet

Post author By Jen McCown
Post date October 11, 2010
Categories In 24HOP, Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, Tips, TSQL
9 Comments on Forgotten T-SQL Cheat Sheet

You’ve seen the blog, you’ve downloaded the code…you even watched the 24HOP session recording…now own the Forgotten T-SQL Cheat Sheet! Yessir, this handy-dandy reference sheet includes the Logical Processing Order of SELECT, shorthand for recursive CTEs and MERGE, the famous list-of-details XML trick, and more! And it’s yours, for only $199.99! FREE! Why? Because we […]

New Hotness: sys.objects and sys.schemas

Post author By Jen McCown
Post date October 8, 2010
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, Tips, TSQL
2 Comments on 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 […]

Tip: OVER and PARTITION BY

Post author By Jen McCown
Post date October 5, 2010
Categories In Beginner, sql server, sqlserverpedia-syndication, SSC, Tips, TSQL
27 Comments on Tip: OVER and PARTITION BY

Here’s a quick summary of OVER and PARTITION BY (new in SQL 2005), for the uninitiated or forgetful.