| TITLE | Recording |
|---|---|
| Tempdb Allocations and Deallocations | Watch Now |
| Tempdb Multiple Data Files | Watch Now |
| Extracting Query Execution Statistics | Watch Now |
| Optimizer Default Guesstimate | Watch Now |
| Parallelism, Execution Context, Wait Types & Task Level Info | Watch Now |
| Logical Reads vs Physical Reads | Watch Now |
| NOLOCK vs READPAST Lock Hints | Watch Now |
| WHERE vs TOP CLAUSE PERFORMANCE COMPARISON | Watch Now |
| CHAR vs VARCHAR – A Simple Performance Story | Watch Now |
| What is a Common Table Expression? | Watch Now |
| SQL Server Management Studio Tips & Tricks | Watch Now |
| Interview Questions & Answers – Wait Types | Watch Now |
| Blocking, Key Lookup & Indexes – A Practical Example | Watch Now |
| SQL Server Scalar Function Death Zone | Watch Now |
| Parameter Sniffing in Action | Watch Now |
| Tuning Indexes To Reduce Memory Grant | Watch Now |
| Query Tuning – Poorly Written Queries | Watch Now |
| Avoid Blocking by Creating Indexes | Watch Now |
| SQL Server Interview Questions & Answers (Indexes. Basic - Part 1) | Watch Now |
| SQL Server Index Interview Questions (BASIC-Part 1) | Watch Now |
| CPU Queue & Affinity in SQL Server | Watch Now |
| How to KILL in SQL Server | Watch Now |
| Stressing SQL Server | Watch Now |
| SQL Server Statistics Update | Watch Now |
| Reason For Early Termination in SQL Server | Watch Now |
| SELECT Statement Without An Access Method | Watch Now |
| CPU Time greater than Elapsed Time? | Watch Now |
| SQL Server Query Cost (by Amit Bansal) | Watch Now |
| SQL Server IO_Completion Wait Type (by Amit Bansal) | Watch Now |
| Removing SORT Operator – SQL Server Execution Plans (by Amit Bansal) | Watch Now |
| TSQL TOP Clause Deterministic vs Non-Deterministic (by Amit Bansal) | Watch Now |
| TSQL WHERE Clause applies after ON Clause (by Amit Bansal) | Watch Now |
| Monitoring Waiting Tasks (Groups) in SQL Server (by Amit Bansal) | Watch Now |
| SQL Server CPU Queue (by Amit Bansal) | Watch Now |
| SQL Server Index Union Operation (by Amit Bansal) | Watch Now |
| SQL Server – Non Clustered Indexes have the Clustering Key (by Amit Bansal) | Watch Now |
| SQL Server – What is my query doing? (by Amit Bansal) | Watch Now |
| SQL Server Cardinality Estimation (by Amit Bansal) | Watch Now |
| Non Clustered Indexes May Hurt Modification Queries Performance (by Amit Bansal) | Watch Now |
| SQL Server Waits - Session vs Task (by Amit Bansal) | Watch Now |
| SCAN vs SEEK Performance – What to look for? (by Amit Bansal) | Watch Now |
| SQL Server Physical Joins - Nested Loop (by Amit Bansal) | Watch Now |
| Finding Most Expensive IO Queries (by Amit Bansal) | Watch Now |
| SQL Server Statistic Histogram in action (by Amit Bansal) | Watch Now |
| SQL Server Query Tuning – What is the execution time? (by Amit Bansal) | Watch Now |
| Avg Disk Sec per Read perfmon counter in SQL Server (by Amit Bansal) | Watch Now |
| SQL Server Statistics Fundamentals (by Amit Bansal) | Watch Now |
| SQL Server Plan Cache Bloating (by Amit Bansal) | Watch Now |
| SQL Server Physical vs Logical IO (by Amit Bansal) | Watch Now |
| SQL Server Order By Clause – Tricky Behavior (by Amit Bansal) | Watch Now |
| SQL Server Sargability and Selectivty Concepts (by Amit Bansal) | Watch Now |
| SQL Server Expensive Lookups (by Amit Bansal) | Watch Now |
| Query Tuning – Estimates vs Actual Runtime Statistics (by Amit Bansal) | Watch Now |
| SQL Server Missing Index Hints Missing (by Amit Bansal) | Watch Now |
| SQL Server Trace Flag 3608 (by Amit Bansal) | Watch Now |
| SQL Server NOT IN clause (by Amit Bansal) | Watch Now |
| Index Usage Stats DMV gets reset (by Amit Bansal) | Watch Now |
| SOS_SCHEDULER_YIELD Wait Type does not show up in Waiting Tasks DMV (by Amit Bansal) | Watch Now |
| SQL Server Stats Objects in action (by Amit Bansal) | Watch Now |
| SQL Server Statistics Histogram Fundamentals (by Amit Bansal) | Watch Now |
| SQL Server Sort Behavior – Basic yet Tricky (by Amit Bansal) | Watch Now |
| PAGEIOLATCH Wait Type in SQL Server (by Amit Bansal) | Watch Now |
| dm_io_virtual_file_stats DMV in SQL Server (by Amit Bansal) | Watch Now |
| Range Scan in SQL Server (by Amit Bansal) | Watch Now |
| SQL Server Deadlock due to Bookmark Lookup (by Amit Bansal) | Watch Now |
| Multiple Index Hints in SQL Server (by Amit Bansal) | Watch Now |
| SQL Server Joins - Inner Join (by Satya Ramesh) | Watch Now |
| SQL Server Isolation Levels - Read Committed (by Satya Ramesh) | Watch Now |
| SQL Server - PIVOT Operator (by Satya Ramesh) | Watch Now |
| SQL Server Ranking Functions - Row Number (by Satya Ramesh) | Watch Now |
| What is SELECTIVITY in SQL Server (by Amit Bansal) | Watch Now |
| SQL Server - Database Restore (by Satya Ramesh) | Watch Now |
| Deadlock within a single table (by Amit Bansal) | Watch Now |
| SQL Server Login Basics (by Amit Bansal) | Watch Now |
| SQL Server - Database Backup (by Satya Ramesh) | Watch Now |
| Extract Wait Type information from the Execution Plan (by Amit Bansal) | Watch Now |
| SQL Server Start Time (by Amit Bansal) | Watch Now |
| SPID blocking itself in SQL Server (by Amit Bansal) | Watch Now |
| Multi Column Index Tuning in SQL Server (by Amit Bansal) | Watch Now |
| Find out IO cost Database wise in SQL Server (by Amit Bansal) | Watch Now |
| Find out CPU cost Database wise in SQL Server (by Amit Bansal) | Watch Now |
| Get the Actual Execution Plan from the Plan Cache (by Amit Bansal) | Watch Now |
| ROLLBACK the TRUNCATE operation (by Amit Bansal) | Watch Now |
| Backup/Restore - The Go-To Option When Data is Truncated (by Amit Bansal) | Watch Now |
| Find what is your query waiting on using Extended Events (by Amit Bansal) | Watch Now |
| Minimize THREADPOOL Wait Type in SQL Server (by Amit Bansal) | Watch Now |
| Understanding SQL Server Memory Grant for Query Execution (by Amit Bansal) | Watch Now |
| Index Seek may not always be faster (by Amit Bansal) | Watch Now |
| Enabling Global Trace Flags in SQL Server (by Amit Bansal) | Watch Now |
| Identifying Page Splits using Extended Events in SQL Server (by Amit Bansal) | Watch Now |
| SQL Server Baselining using PerfMon Counters (by Amit Bansal) | Watch Now |
| SQL Server Implicit Conversion Part 2 (by Amit Bansal) | Watch Now |
| SQL Server Implicit Conversion Part 1 (by Amit Bansal) | Watch Now |
| Tempdb Full Why? (by Amit Bansal) | Watch Now |
| SQL Server CPU Consumption by Database (by Amit Bansal) | Watch Now |
| Counting SQL Server Tasks (by Amit Bansal) | Watch Now |
| SQL Server DMVs for Query and Stored Procedure Tuning (by Amit Bansal) | Watch Now |
| First Steps with Windows Debugger for SQL Server (by Amit Bansal) | Watch Now |
| Tracking Buffer Pool Memory in SQL Server (by Amit Bansal) | Watch Now |
| SQL Server Index Page Splits and Fragmentation (by Amit Bansal) | Watch Now |
| For how long is my SQL Server instance running? (by Amit Bansal) | Watch Now |
| Seeking on Multi Column Indexes in SQL Server (by Amit Bansal) | Watch Now |
| SQL Server Query Memory Grant (by Amit Bansal) | Watch Now |
| CXPACKET Wait Type in SQL Server – Part 2 (by Amit Bansal) | Watch Now |
| CXPACKET Wait Type in SQL Server – Part 1 (by Amit Bansal) | Watch Now |
| SQL Server CPU Monitoring (by Amit Bansal) | Watch Now |
| Density Factor in SQL Server (by Amit Bansal) | Watch Now |
| Tracking IO Consumption Database-Wise in SQL Server (by Amit Bansal) | Watch Now |
| Tracking CPU Time Consumption Database Wise in SQL Server | Watch Now |
| Trace Flags in SQL Server (by Amit Bansal) | Watch Now |
| SQL Server Tempdb Internals & Monitoring (by Amit Bansal) | Watch Now |
| SQL Server Monitoring Using Performance Counters | Watch Now |
| SQL Server Index Internals Page Splits and Fragmentation (by Amit Bansal) | Watch Now |
| SQL Server Index Internals and Tuning Column Sort Order (by Amit Bansal) | Watch Now |
| Monitoring SQL Server Task Pressure (by Amit Bansal) | Watch Now |
| Identifying Page Splits Using Extended Events (by Amit Bansal) | Watch Now |
| Extended Events Tips & Tricks (Detailed) by Amit Bansal | Watch Now |
| Why are Missing Index Hints Missing (by Amit Bansal) | Watch Now |
| Finding Expensive Lookups in SQL Server (by Amit Bansal) | Watch Now |
SQL Server Education (by the geeks, for the geeks)