SQL Server Videos

More info on SQL Server Workshops and Consulting

Subscribe to our newsletter and we will keep you updated on new video releases. Interested to see videos on a specific topic? Write to us!


Tempdb Metadata Contention in SQL Server - Table Variable Vs Temporary Table

More info: http://www.sqlvideo.com/AllVideos/Tempdb-Metadata-Contention---Table-Variable-Vs-Temporary-Table

AlwaysOn Availability Groups Synchronous Replica Readable Secondary Data Access Latency

More info: http://www.sqlvideo.com/AllVideos/AlwaysOn-Synchronous-Replica-Readable-Secondary-Data-Latency

Seek or Scan - Cost Based Optimizer in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Seek-or-Scan---Cost-Based-Optimizer-in-SQL-Server

Optimize for Ad Hoc Workloads - SQL Server Configuration Parameter

More info: http://www.sqlvideo.com/AllVideos/Optimize-for-Ad-Hoc-Workloads---SQL-Server-Parameter

Extended Event Locks Lock Waits in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Extended-Event-Locks-Lock-Waits-in-SQL-Server

Extended Event Query Post Execution Showplan in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Extended-Event-Query-Post-Execution-Showplan-in-SQL-Server

PAGELATCH Waits with Update Statements in SQL Server - PAGELATCH_EX and PAGELATCH_SH

More info: http://www.sqlvideo.com/AllVideos/PAGELATCH-Waits-with-Update-Statements-in-SQL-Server

Tempdb Allocation Contention in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Tempdb-Allocation-Contention-in-SQL-Server

In-Memory OLTP Memory Optimized Table Variables Vs Disk Based Table Variable in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Memory-Optimized-Table-Variables-Vs-Disk-Based-Table-Variable

Temp Table Caching in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Temp-Table-Caching-in-SQL-Server

Filtered Statistics in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Filtered-Statistics-in-SQL-Server

Parallel Insert Into - Table Variable Vs Temporary Table in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Parallel-Insert-Into---Table-Variable-Vs-Temporary-Table

Cardinality Estimation - Table Variable Vs Temporary Table in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Cardinality-Estimation---Table-Variable-Vs-Temporary-Table

Understanding ASYNC_NETWORK_IO Waits in SQL Server

More info: http://www.sqlvideo.com/AllVideos/Understanding-ASYNC_NETWORK_IO-Waits-in-SQL-Server

Resource Governor in SQL Server - Workload Throttling

More info: http://www.sqlvideo.com/AllVideos/Resource-Governor-in-SQL-Server---Workload-Throttling

Data Compression in SQL Server - Pros and Cons

More info: http://www.sqlvideo.com/AllVideos/Data-Compression-in-SQL-Server---Pros-and-Cons

SQL Server Command Timeout - Application Timeout - Attention

More info: http://www.sqlvideo.com/AllVideos/SQL-Server-Command-Timeout---Application-Timeout---Attention

NUMA remote (foreign) memory access overhead on Windows

More info: http://www.sqlvideo.com/AllVideos/NUMA-remote-memory-access-overhead-on-Windows-and-SQL-Server


NUMA remote (foreign) memory access overhead on SQL Server for Disk based Tables

More info: http://www.sqlvideo.com/AllVideos/NUMA-remote-memory-access-overhead-on-Windows-and-SQL-Server


NUMA remote (foreign) memory access overhead for SQL Server In-Memory OLTP Memory optimized Tables

More info: http://www.sqlvideo.com/AllVideos/NUMA-remote-memory-access-overhead-on-Windows-and-SQL-Server

Slow performance due to SQL Server 2014 Buffer Pool Extension (BPE) and serial queries (MAXDOP 1)

More info: http://www.sqlvideo.com/AllVideos/SQL-Server-2014-BPE-Performance-Issue

Tags

AlwaysOn Availability Groups   Application Timeout   ASYNC_NETWORK_IO   Asynchronous Replica   Attention   BPE   Command Timeout   CPU Throttling   Data Compression   Data Latency   Dynamic SQL   Estimation   Execution Plan   Extended Events   Filtered statistics   In-memory OLTP   Locking   locks lock waits   Memory Optimized Table Variable   NUMA   optimize for ad hoc workloads   Optimizer   PAGELATCH_EX   PAGELATCH_SH   Parameterization   query post execution showplan   Readable Secondary   Resource Governor   Scan   Seek   sp_executesql   sp_whopro   SQL Server   SQLTest   Stored Procedure   Synchronous Replica   Table Variable   Temp Table Caching   Tempdb   Tempdb Allocation Contention   Tempdb Metadata Contention   Temporary Table   Wait Stats   Workload Throttling  

VISIT ALSO OUR SISTER PAGES