No, I’m not talking about the DAY() function that you’d find if you Googled anything related to “SQL Server” and “day.”
How to Increase SQL Server Query Performance When You Have No Control Over the Query — A Unique Approach
Last week, at my local PASS chapter (Rochester), I gave a presentation titled “Magical Query Tuning.” In the presentation, I described a query-tuning technique that can be used when you think you’re out of options. I first learned of this method from Kendra Little at LittleKendra.com and I think it’s an incredibly interesting and not widely-known method, which is why I chose to share it with everyone.
I’m a huge proponent of SQL Server. I think it’s a great database engine and I find that I’m always looking for ways to expand my knowledge about the product and help others expand theirs. In that vein, starting in October of this year I’ve begun tweeting one SQL Server function and a link to its page on microsoft.com, each Friday. I call it Function Friday.