Below is a script I recently used on a project to dynamically generate and execute the statements needed to clear all the data out of a database. It is heavily borrowed from a blog post … Continue reading Generating a Database Clean Up Script
Static Code Analysis and SARG-ability
This morning while coding a stored procedure for a SQL Server 2012 SSDT project in Visual Studio, I noticed an interesting little blue squiggly under one of the column references in the WHERE-clause of the … Continue reading Static Code Analysis and SARG-ability