SQL Server Tutorials

Partial Aggregate Operator in SQL Server

Inequality Logic Optimization in SQL Server

Demystifying Nested Loop vs Merge Join

SQL Webinars

CXCONSUMER Wait Type

CXPACKET Wait Type

AdHoc Query Plan Caching

SQL Server Shorts


Upcoming SQL Server Webinars – Oct 26

Latest Master Class Recordings

Master Class Recordings available

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