SQL Server Tutorials & Demos

TITLERecording
Parsing SP_Server_Diagnostics Output Watch Now
SQL Server Ranking Functions – A Silent Guide Watch Now
DELETING DUPLICATE ROWS Watch Now
SQL Server Memory Utilization History Watch Now
SQL Server Plan Cache Memory Impact Watch Now
Index Selection Mechanisms in SQL Server Part 1 Watch Now
CPU Utilization History Watch Now
SQL Server Indexing Strategy Puzzle Watch Now
ASYNC_NETWORK_IO WAIT TYPE Watch Now
Auto Statistics Update Threshold in SQL Server Watch Now
Clustered Index Seek Trivia in SQL Server Watch Now
Join Order by SQL Server Query Optimizer Watch Now
Computing Estimated Operator Cost in SQL Server Watch Now
Estimated IO Cost Watch Now
Compute Scalar Operator and Stream Aggregate in SQL Server Watch Now
Find out Top Waits in SQL Server Watch Now
SQL Server Index Internals Challenge Watch Now
Index Union in SQL Server Watch Now
Dynamic Index Seek in SQL Server Watch Now
Many Indexes May Hurt Performance Watch Now
Partition-Level Locking Performance Technique Watch Now
Memory Grant Warning in SQL Server Watch Now
Ad Hoc Query Caching in SQL Server Watch Now
SQL Server High Memory Usage Watch Now
FILL FACTOR in SQL Server Watch Now
Capture SQL Server Query Execution using Extended Events Watch Now
WRITELOG Wait Type in SQL Server (The Answer) Watch Now
High CPU Usage Caused by SQL Server Watch Now
WRITELOG Wait Type in SQL Server (The Question) Watch Now
Fuzzy String Matching (Query Tuning) Watch Now
Clustering Key Choices (Index Tuning) Watch Now
Troubleshooting SQL Server Plan Cache Watch Now
SUBSTRING vs LIKE (Query Tuning) Watch Now
UPDATE STATS with ROWCOUNT (Query Tuning Trick) Watch Now
TempDB Sort Spilling (SQL Server Query Tuning) Watch Now
Dedicated Administrator Connection in SQL Server Watch Now
No Join Predicate Warning Watch Now
BETWEEN vs IN – Are they the same? Watch Now
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