Category: Level

Compare column names for case sensitivity

Post author By Jen McCown
Post date January 25, 2017
Categories In Beginner, sqlserverpedia-syndication, SSC, Tech and Learning, Tips
3 Comments on Compare column names for case sensitivity

I’m reviewing the code for the upcoming Minion CheckDB, and one of the things we’re checking for is case consistency in column names. For example, if Table1 has a column named Col1, and Table2 has COL1, well that’s no good. But, how do we easily find those mismatches on a system that’s not case sensitive? Easy: […]

An MCM teaches COMMENTS at SQL Saturday OKC

Post author By Jen McCown
Post date August 26, 2016
Categories In Admin, Applied SQL, Beginner, Dev, News, SQL Saturday, sqlserverpedia-syndication, SSC, Tech and Learning, Tips

Edit: SQL Sat OKC has come and gone, but the new session on comments is recorded and up on the MidnightDBA Events page! (Direct link to WMV.) Tomorrow (as of the blog’s publish date) at8:30am, I will be teaching “T-SQL’s Hidden Support Feature” at SQL Saturday Oklahoma City (totally free, did you know? Free IT training, y’all.) I said […]

Easy SQL mistakes: Accidental Correlated Subquery

Post author By Jen McCown
Post date April 18, 2016
Categories In Beginner, sqlserverpedia-syndication, SSC, Tips
2 Comments on Easy SQL mistakes: Accidental Correlated Subquery

Just a fun note, because it was a moment of pure puzzlement for me. I’m writing a new SP for Minion Backup (you knew it had to be Minion related, didn’t you?) and I just got the oddest error. Here’s how it went. First, I got a list of backups from the log: SELECT ExecutionDateTime , Status , PctComplete , […]