Home
Blogs
DBAs@Midnight
Admin
Dev
Midnight Snacks
All Vids
Events
Contact
Links
NTSSUG

Leave a comment.

Name:
Email:
Comment:
(500 chars.)

0 of 500.
What's the picture?



Optimize Query by Intervals


Author: Jennifer McCown
Date: 11/17/2009
Length: 14:35
Size: 25,391 KB

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

Right-click to download video

Others in Series:

You might also like:

Dirty Tricks: Text Manipulation
Beginning T-SQL: SQL Saturday #41 - Atlanta
UNION and UNION ALL
OR is bad, IF is good
TSQL: Grouping Basics