SQL Server Tutorials

SQL Server Memory Utilization History

SQL Server Plan Cache Memory Impact

Index Selection Mechanisms in SQL Server Part 1

SQL Webinars

SQL Server Performance Tuning Made Simple – Part 1

SQL Server Indexing Architecture – Part 1

Query Tuning – What Really Happened

SQL Server Shorts

Simple Plan Cache Metrics

Full or Partial SEEK?


Why SCAN instead of SEEK

SQLShighra Videos

Session Level Wait vs Task Level Wait in SQL Server

The Real Impact of Implicit Conversions on SQL Server

RESOURCE SEMAPHORE Wait Type

Conference Sessions

SQL Server Memory Internals & Troubleshooting

Developer Best Practices in SQL Server

Back to Indexes – The Original Culprit – Amit Bansal’s TechEd North America 2012 session!

Geek Talks

Geek Talk #4 on Three Query Tuning Techniques For SQL Developers

Geek Talk #3 on Implementing SQL Server Extended Events

Geek Talk #2 on Implementing Extended Events Part 2