Category: Beginner

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

Ground Zero Database Design: Part 2

Post author By Jen McCown
Post date October 20, 2010
Categories In Beginner, Intermediate, sql server, sqlserverpedia-syndication, SSC, Tips
6 Comments on Ground Zero Database Design: Part 2

Last week I wrote Ground Zero Database Design, thinking that was a good enough bare-bones intro (with recommended reading!) that I could leave the subject alone for a while. Then I went looking through my blog ideas folder, and found this: DB design note:A column must mean what it means always, not just in steps […]

Ground Zero Database Design

Post author By Jen McCown
Post date October 14, 2010
Categories In Beginner, sql server, sqlserverpedia-syndication, SSC
2 Comments on Ground Zero Database Design

All the SQL world should take database modeling classes, and thrive in the light of well-designed data structures. Back in the real world, though, an awful lot of folk who model DBs – or just add new database objects – miss, forget, or ignore basic normalization principles. For your consideration, Ground Zero Database Design guidelines: […]