Posted on May 7, 2012
Finding crap in the SQL Server database
Anyone who has ever maintained an old legacy code base often finds themselves working with a decade old database schema that now spans hundreds of tables, each of which contain dozens of columns. Trying to locate a particular… Read More
Posted on December 19, 2011
TSQL PIVOT
The TSQL PIVOT command is an operation that essentially rotates a set of table data. The end result is a transform that converts columns into rows. One common usage of PIVOT is to normalize denormalized data. This may… Read More
Posted on May 23, 2011
Quick and dirty table import hack for SQL Server
Every so often, I’ve needed to import data from the QA/Staging database table onto my local machine to help troubleshoot a hard to repro bug. Typically, I only need to import a few table’s worth of data, so… Read More
Posted on May 2, 2011
TSQL query the missing gaps in a table
I’m currently studying to get a Microsoft SQL Server 2008 Database Development Certificate and am going through their official 70$ 400 + page training kit. It covers a wide variety of topics, one of them being how to… Read More
Posted on October 1, 2010
Database isolation levels
I remember a job interview where I was asked to rate my SQL Server experience on a scale of 1 to 10. Not wanting to put my foot in my mouth, I responded with a modest 6…. Read More