Massive SQL Date Time Cheat Sheet
Massive SQL Date Time Cheat Sheet Anyone who has been involved in SQL will undoubtedly tell you wargames they played when they had to manipulate date time data via SQL.…
SQL: comparing values IN vs INNER JOIN
IN Vs INNER JOIN Here we will do a quick benchmark on using IN vs INNER JOIN. This came about when a coworker had to run a one-off SQL statement…
SQL: get max length of values in every table column
SQL to get max length of values in every table column I had an issue to resolve once upon a time where data could not be loaded into a table…
SQL: “Watchdog” loop to start and monitor SQL Agent Jobs
SQL “Watchdog” loop to start and monitor SQL Agent Jobs This runs an SQL “Watchdog” loop to start and monitor SQL Agent Jobs. There are just a few configurable items…
SQL: Rebuild Indexes, Update Statistics, and Shrink Databases on SQL Server
SQL to Rebuild Indexes, Update Statistics, and Shrink Databases Here is SQL to Rebuild Indexes, Update Statistics, and Shrink Databases on SQL Server. This code works on SQL Server 2008…
Tricky C# and SQL Interview Questions
Tricky C# and SQL Interview Questions for mid-to-senior level Positions A few readers have left private comments asking me what kinds of interview questions I’ve asked potential candidates. Personally, I…
SQL: LIKE vs SUBSTRING vs LEFT/RIGHT vs CHARINDEX
LIKE vs SUBSTRING vs LEFT/RIGHT vs CHARINDEX All too often developers need to query a database table for records which begin and/or end with a certain textual pattern. For instance,…
SQL: Fastest way to insert new records where one doesn’t already exist
Fastest way to insert new records where one doesn’t already exist SQL Developers come across this scenario quite often – having to insert records into a table where a record…
SQL: Fastest way to compare multiple column values
Fastest way to compare multiple column values I was recently working on a project with stored procedures that had a significant amount of column comparisons in a MERGE statement. This…
Optimizing SQL Strategies
Optimizing SQL Strategies How many of you have come across SQL code that, for whatever reason, wasn’t written as good as it could have been? I’m not talking about going…