Bust the Cache “With Recompile”.
Friday, May 15th, 2009In SQL Server, an execution plan is a calculation of the most…
Read MorePosts Tagged ‘SQL Server’
SQL Server 2008 – Service Pack 1 Released
Thursday, April 9th, 2009Microsoft has released SQL Server 2008 Service Pack 1. This…
Read MoreCommon Table Expressions at PASS
Tuesday, January 27th, 2009On Tuesday, I gave a presentation on SQL Server Common Table Expressions at the monthly meeting of the Fort Wayne chapter of PASS (Professional Association for SQL Server). It was quite clearly a rousing success, well attended, and sure to be talked about long after Common Table Expressions become the subject of vintage technology jokes and bad career choices.
Read MoreSQL Server 2005 – Service Pack 3 Released
Tuesday, December 16th, 2008Microsoft has released SQL Server 2005 Service Pack 3. This…
Read MoreArchitecture Notes - .NET SQL Stored Procedures for System Integration
Monday, October 13th, 2008I remember when SQL Server 2005 was coming out there…
Read More