Stuff I learned … yesterday – statistics
Yesterday was a pretty full day between training and the ONSSUG June meeting immediately afterwards, so I didn’t get a chance to blog. Anyway, I did learn something yesterday, but it didn’t come from the class I’m taking. Erin Stellato (blog | twitter) gave a great presentation at ONSSUG about statistics. I really wish she’d had more [...]
June 8, 2011
Tags: SQL tuning, statistics Posted in: Features, SQL Tuning 
No Comments
Plan guides and parameterization
We’ve all had this experience. A third party application is running a piece of sql that simply isn’t choosing the best query plan, and if only it would use a hash join instead of a nested loop. Or maybe it’s blocking other processes and a nolock hint would help. The problem is, you can’t change [...]
February 9, 2011
Tags: parameterization, plan guide, SQL tuning Posted in: SQL Tuning, T-SQL No Comments
