Category: Tech and Learning

Tip: Schema Qualify Objects in SPs

Post author By Jen McCown
Post date December 6, 2010
Categories In Beginner, sql server, sqlserverpedia-syndication, SSC, Tips, TSQL
4 Comments on Tip: Schema Qualify Objects in SPs

“Eat your broccoli.” “Wear your gloves.” “Schema qualify your objects.” Your Mom wasn’t kidding, and she always gave the best advice. We’ve already seen how it would have paid off for us to end all T-SQL statements with a semicolon, even though it’s not currently required – after all, don’t CTEs and MERGE statements have […]

What’s New in SQL Server “Denali” CTP1

Post author By Jen McCown
Post date November 18, 2010
Categories In News-ish, Powershell, sql server, SQLPASS, sqlserverpedia-syndication, SSC, SSIS, TSQL
5 Comments on What’s New in SQL Server “Denali” CTP1

How many of you have heard that the Community Technology Preview (CTP1) for the next version of SQL Server is out? Well, now all of you have. You can download and play with the Denali preview here. Now, if you’re patting yourself on the back for already having heard the news, lemme ask you […]

MERGE Statement Corrected, or, How to Eat Crow in Public

Post author By Jen McCown
Post date November 3, 2010
Categories In 24HOP, 24HOP, Beginner, Intermediate, News-ish, NTSSUG, sql server, SQLPASS, sqlserverpedia-syndication, SSC, TSQL
5 Comments on MERGE Statement Corrected, or, How to Eat Crow in Public

I have no excuse, none whatsoever. In my T-SQL Brush-Up presentation to the North Texas SQL Server User Group (NTSSUG) in September – and again in the T-SQL Brush-Up 24HOP session I gave that same day – I mentioned that you can only have one WHEN NOT MATCHED clause in a MERGE statement (as per SQL […]