Entries Published On August, 2012
Diving Into the Deep End with ColumnStore Indexes
Currently, I’m working with a client to develop a custom database application that will be used for tracking and reporting on account receivables. We have estimated between 2-3 billion transactions per year and need to maintain 3 years of history…so it will be a fairly large database. But more interesting that the sheer size of …
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 …