SQLWorkshops

Cardinality Estimation - Table Variable Vs Temporary Table in SQL Server

Extended Event Query Post Execution Showplan in SQL Server

Understanding ASYNC_NETWORK_IO Waits in SQL Server

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

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

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

SQL Server Command Timeout - Application Timeout - Attention

AlwaysOn Availability Groups Synchronous Replica Readable Secondary Data Access Latency

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

Extended Event Locks Lock Waits in SQL Server

Resource Governor in SQL Server - Workload Throttling

Data Compression in SQL Server - Pros and Cons

sp_whopro Getting Started Part 1

Seek or Scan - Cost Based Optimizer in SQL Server

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

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

Filtered Statistics in SQL Server

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

Tempdb Allocation Contention in SQL Server

Optimize for Ad Hoc Workloads - SQL Server Configuration Parameter