Author: Jen McCown

Tim Ford (blog, Twitter) tagged me thusly: What have you implemented from the PASS Summit 2009?  Did you find yourself using the code available without tweaks?  If not, what did you have to do in order to get the code to function in your environment?  What do you still intend to implement? I ask these questions […]

Here’s the accompanying video – same material, different format. A solution is ever so much more elegant if you know the path that led to it.  Which is another way of saying, you only know how totally smart I am if you see how much work I had to do 🙂 I had to do a […]

Here’s the accompanying video – same material, different format.  Here’s a common mistake: using OR instead of IF.  Let’s say you want to get sales by a time interval, either current week or current month.  This will not perform well: IF @Interval = ‘wk’ SELECT SUM(o.Sale) AS Sales FROM Orders o WHERE o.BizID = @BizID […]