Mike Scalise

Mike Scalise

My thoughts on SQL Server, Project Management, Fitness, and all points in between

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.

Read More

Function Friday

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.

Read More