SQL Server Tutorials & Demos

TITLERecording
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