Category: Tech and Learning

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.

How to Prove a Fact (Again)

Post author By Jen McCown
Post date September 29, 2010
Categories In sql server, sqlserverpedia-syndication, SSC, Tips
15 Comments on How to Prove a Fact (Again)

Sean’s latest rant – about a vendor with a dangerously small amount of SQL knowledge – has spurred me to talk about a common theme I’ve been seeing lately: Proving facts to ignoramuses*. How to Prove Facts to the Unbeliever State the fact. Explain the fact. Restate the fact. [Realize here that they won’t listen […]