DevCheats – Writing Better SQL Queries

DevCheats-SQLQueries

 

In the first episode of DevCheats, CEO and Founder of Stackify, Matt Watson, demonstrates some tips, tricks and free tools to help write better SQL queries.

Topics can be found at:

0:35 Using SQL Statistics
0:54 Finding high query reads
1:30 CPU time vs Elapsed Time
2:18 Execution Plans
2:45 Index Seek vs Index Scan
3:34 Supratimas
4:45 ALT-F1 Shortcut
5:24 SQL Search tool