Categories
Uncategorized

Generating a Database Clean Up Script

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 by Nikola Ilijev.¬† I just added the parts pertaining to the dropping and re-creating of the ColumnStore index objects and […]

Categories
Uncategorized

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 statement I was working on. ¬†Curiously, I hovered the mouse over it and was pleasantly surprised to see the following […]