Watching Optimize Query by Intervals

In this vid, I walk you through tuning a query full of date manipulation (which is performance death). I show you how to free the functions, free the optimizer, and happify your code...plus we talk a little date math. See the accompanying blog at http://midnightdba.itbookworm.com/midnightdba/blog/post/Optimized-Query-by-Hour2c-Day2c-Week2c-or-Month.aspx

 

Author: Jennifer McCown

Filmed: 12/1/2009

Length: 14:35 minutes

Size: 25,391 KB

Click here to download the video!