A Few Useful T-SQL Date Functions
Monday, July 13th, 2009I was working on a project the other day and…
Read MoreArchive for the ‘SQL Server’ Category
Bust the Cache “With Recompile”.
Friday, May 15th, 2009In SQL Server, an execution plan is a calculation of the most…
Read MoreSQL 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 More