Browsing the blog archives for December, 2009

Charlotte SQL Server Users Group, Guest Speaker Kevin Kline

Just in time for the Holidays…  Kevin Kline has come to town. Kevin’s topic at the Charlotte SQL Server Users Group weighed the pros and cons of SQL Server virtualization.  In this post I will note some of the many points that I learned. Before I dive into the technology details I would like to […]

Change column data type; change NULL constraint

Recently I’ve been working on performance issues relating to SELECT queries hitting some very large data warehouse stage tables.  In one instance I encountered a table that had over 300M records where the SELECT statement that reads from the STAGE table had an estimated execution cost of 3500.  I didn’t find this by accident… it […]