15Nov 2010 by Grant Fritchey 4 Comments

Switching Off Parameter Sniffing

Uncategorized
Or, another way to put it, in most cases, shooting yourself in the foot. I was not aware that the cumulative update for SQL Server 2008 back in June included a switch that allows you to turn parameter sniffing off within SQL Server. Thanks to Kendra Little (blog|twitter) for letting me know about it (although she let me know by "stumping the chump" during my lightening talk at the Summit, thanks Kendra!). When I first saw the switch, I thought about the places where switching off parameter sniffing could be helpful. But, as I thought about it, the more I realized that this was an extremely dangerous switch. Why? Because, most people only ever hear about parameter sniffing when they run into a problem. Someone says "Parameter sniffing" and you see people cringe.…
Read More
15Nov 2010 by Grant Fritchey 2 Comments

ScaryDBA Blog Reboot

Misc
After all the conversations at FreeCon last week (more on that later, when I've assimilated it better), I finally decided to make some changes. The list of things I'm hitting is extremely long, but I'm going to be going through them a few at a time. First, and easiest, was getting moved off the WordPress domain to my own, hosted, domain. You're seeing the results. This is the new ScaryDBA blog. I suspect the theme may change once or twice over the next week, but basically, all the functionality that has been added, better feeds, conversation tracking, other stuff, will remain. Thank you for visiting in the past. I intend to provide you with plent of reasons to visit in the future.
Read More