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. Here are code snippets to multiple Date and Time… Continue Reading
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 to see if approximately 3,500 codes (from a supplied… Continue Reading
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 because “string or binary data would be truncated”. The target… Continue Reading
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 that you can adjust to suit your needs: The “Wait… Continue Reading
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 – 2016. It should help keeping your databases running at… Continue Reading
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 have a lot more fun with mid-to-senior level positions as… Continue Reading