Browse by Tags

• date
• datetime

• What Happened Today? DATE and Date Ranges Over DATETIME

  A few days ago Aaron posted yet another fantastic entry in his Bad Habits series, this one discussing mishandling of date ranges in queries . This is a topic near and dear to me, having had to clean up a lot of poorly thought out code in the past few Read More... Posted Tuesday, October 20, 2009 3:21 PM by Adam Machanic | 14 Comments Filed under: date, datetime, Optimization, Performance, T-SQL

• Controlling Stored Procedure Caching with ... Dyanmic SQL?!?

  Tell me if this situation sends a chill down your spine: You've written a stored procedure, tested it against a variety of inputs, and finally rolled it out in production. All is well... Or so you think. You start getting complaints from some users that Read More... Posted Wednesday, July 12, 2006 10:19 PM by Adam Machanic | 3 Comments Filed under: Optimization, Performance, T-SQL