SQL Server Tutorials

WRITELOG Wait Type in SQL Server (The Question)

Fuzzy String Matching (Query Tuning)

Clustering Key Choices (Index Tuning)

SQL Webinars

T-SQL Tips & Tricks

SQL Server Scheduling Architecture

Configuring SQL Server For Better Performance

SQL Server Shorts

CPU Intensive Queries Currently Running

CPU PERCENTAGE USED by SQL Server Queries

SQL Server OS RING BUFFERS DMV

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