Tag Archives : SQL tuning

---

Stuff I learned … yesterday – statistics

This entry was posted in Features SQL Tuning and tagged SQL tuning statistics on June 8, 2011 by Colleen M. Morrow

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 […]

---

Plan guides and parameterization

This entry was posted in SQL Tuning T-SQL and tagged parameterization plan guide SQL tuning on February 9, 2011 by Colleen M. Morrow

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 […]

---