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
Length: 14:35 minutes
Size: 25,391 KB
I do all my videos with Camtasia Studio. It's the bomb.