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 Watch Now
SQL Server IO_Completion Wait Type (by Amit Bansal) Watch Now
Find out IO cost Database wise in SQL Server (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 Sargability and Selectivty Concepts Watch Now
SQL Server Expensive Lookups (by Amit Bansal) Watch Now
SQL Server Missing Index Hints Missing (by Amit Bansal) Watch Now
Backup/Restore - The Go-To Option When Data is Truncated (by Satya Ramesh) Watch Now
ROLLBACK the TRUNCATE operation Watch Now
SQL Server Baselining using Perfmon Counters Watch Now
SQL Server Monitoring Using Performance Counters
Watch Now
Counting SQL Server Tasks (by Amit Bansal) Watch Now
Tempdb Full Why? (by Amit Bansal) Watch Now
Find out CPU cost Database wise in SQL Server (by Amit Bansal) Watch Now
Identifying Page Splits using Extended Events in SQL Server (by Amit Bansal) Watch Now
SQL Server Index Page Splits and Fragmentation (by Amit Bansal) Watch Now
Multi Column Index Tuning in SQL Server (by Amit Bansal) Watch Now
Enabling Global Trace Flags in SQL Server (by Amit Bansal) Watch Now
Tracking Buffer Pool Memory 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
SQL Server DMVs for Query and Stored Procedure Tuning (by Amit Bansal) Watch Now
Seeking on Multi Column Indexes in SQL Server (by Amit Bansal) Watch Now
First Steps with Windows Debugger for SQL Server (by Amit Bansal) Watch Now
CXPACKET Wait Type in SQL Server - Part 1 (by Amit Bansal) Watch Now
SQL Server Start Time (by Amit Bansal) Watch Now
SQL Server CPU Monitoring (by Amit Bansal) Watch Now
SQL Server Login Basics (by Satya Ramesh) Watch Now
SQL Server - Database Restore (by Satya Ramesh) Watch Now
Density Factor in SQL Server (by Amit Bansal) Watch Now
SQL Server - Database Backup (by Satya Ramesh) Watch Now
What is SELECTIVITY in SQL Server (by Amit Bansal) Watch Now
SQL Server Ranking Functions - Row Number (by Satya Ramesh) Watch Now
SQL Server - PIVOT Operator (by Satya Ramesh) Watch Now
SQL Server Physical Joins - Nested Loop (by Satya Ramesh) Watch Now
SQL Server Isolation Levels - Read Committed (by Satya Ramesh) Watch Now
SQL Server Joins - Inner Join (by Satya Ramesh) Watch Now
Multiple Index Hints in SQL Server (by Amit Bansal) Watch Now
Range Scan in SQL Server (by Amit Bansal) Watch Now
PAGEIOLATCH Wait Type in SQL Server (by Amit Bansal) Watch Now
Finding Most Expensive IO Queries (by Amit Bansal) Watch Now
Avg Disk Sec per Read perfmon counter in SQL Server (by Amit Bansal) Watch Now
dm io virtual file stats DMV in SQL Server (by Amit Bansal) Watch Now
SQL Server Statistic Histogram in action (by Amit Bansal) Watch Now
SSMS Index Hints (by Amit Bansal) Watch Now
SQL Server Stats Objects in action (by Amit Bansal) Watch Now
SQL Server Statistics Fundamentals (by Amit Bansal) Watch Now
SQL Server Statistics Histogram Fundamentals (by Amit Bansal) Watch Now
SQL Server Statistics Histogram Fundamentals (by Amit Bansal) Watch Now
Understanding SQL Server Memory Grant for Query Execution Watch Now
SQL Server Waits - Session vs Task (by Amit Bansal) Watch Now
SQL Server Wait Types Terminologies (by Amit Bansal) Watch Now
Find what is your query waiting on using Extended Events (by Amit Bansal) Watch Now
SQL Server Cardinality Estimation (by Amit Bansal) Watch Now
SQL Server Trace Flag 3608 (by Amit Bansal) Watch Now
SQL Server CPU Consumption by Database (by Amit Bansal) Watch Now
For how long is my SQL Server instance running? (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
Implicit Conversion in SQL Server - Part 2 (Amit Bansal) Watch Now
Implicit Conversion in SQL Server - Part 1(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