Monday, May 10, 2010

.Net Uses Group Meeting May 10, 2010 - Optimizing SQL

Wes Brown talked to 55 attendees about how to optimize SQL queries. My random notes:
Your DBA should be updating the STATS at least once a day for databases with changes.
Before running trial queries use "Set statistics io on" and Set statistics time on"
A Clustered index is a must for any table, whether it really needs it or not.
Optimize Logical Reads first, before looking at cpu.

The usual .Net crowd was noticeable by their absence; perhaps a sign that NHibernate is doing all the optimization people think they need.