Tag Archive For "SSDT"
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 …
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 …