Канал: SQLMaestros

MISSING WAITS (CXCONSUMER)

MISSING WAITS (CXCONSUMER)

SQL Server Wait Types Part 2

SQL Server Wait Types Part 2

What is your SQL Server Query doing?

What is your SQL Server Query doing?

SQL Server Eager Index Spool (Short)

SQL Server Eager Index Spool (Short)

INEQUALITY with SCAN vs EQUALITY with SEEK

INEQUALITY with SCAN vs EQUALITY with SEEK

SQL Server Wait Types – Part 1

SQL Server Wait Types – Part 1

SQL Server CXConsumer Wait Type

SQL Server CXConsumer Wait Type

EQUALITY vs INEQUALITY

EQUALITY vs INEQUALITY

Parsing SP_Server_Diagnostics Output

Parsing SP_Server_Diagnostics Output

Difference between RANK and DENSE_RANK

Difference between RANK and DENSE_RANK

SQL Server Ranking Functions – A Silent Guide

SQL Server Ranking Functions – A Silent Guide

Join Condition Weirdness – Be Careful

Join Condition Weirdness – Be Careful

DELETING DUPLICATE ROWS

DELETING DUPLICATE ROWS

Grouping & Aggregation in Extended Events

Grouping & Aggregation in Extended Events

SQL Server Performance Tuning Made Simple – Part 2

SQL Server Performance Tuning Made Simple – Part 2

SQL Server Memory Utilization History

SQL Server Memory Utilization History

Simple Plan Cache Metrics

Simple Plan Cache Metrics

SQL Server Performance Tuning Made Simple – Part 1

SQL Server Performance Tuning Made Simple – Part 1

SQL Server Plan Cache Memory Impact

SQL Server Plan Cache Memory Impact

How to watch contents of All-in-One Bundle

How to watch contents of All-in-One Bundle

How to subscribe All-in-One Bundle

How to subscribe All-in-One Bundle

Full or Partial SEEK?

Full or Partial SEEK?

Inefficient Index Seeks

Inefficient Index Seeks

Index Selection Mechanisms in SQL Server Part 1

Index Selection Mechanisms in SQL Server Part 1

Why SCAN instead of SEEK

Why SCAN instead of SEEK

CPU Utilization History

CPU Utilization History

Reviewing CPU Configuration

Reviewing CPU Configuration

SQL Server Indexing Strategy Puzzle

SQL Server Indexing Strategy Puzzle

SQL Server Query Cost

SQL Server Query Cost

The Power of Indexes

The Power of Indexes

SQL Server Query Optimizer – Lesser Known Things

SQL Server Query Optimizer – Lesser Known Things

ASYNC_NETWORK_IO WAIT TYPE

ASYNC_NETWORK_IO WAIT TYPE

Async Network IO Wait Type

Async Network IO Wait Type

SQL Server Query Tuning Tools

SQL Server Query Tuning Tools

Auto Statistics Update Threshold in SQL Server

Auto Statistics Update Threshold in SQL Server

DBCC TRACE Commands in SQL Server

DBCC TRACE Commands in SQL Server

Clustered Index Seek Trivia in SQL Server

Clustered Index Seek Trivia in SQL Server

Get Actual Execution Plan in SQL Server

Get Actual Execution Plan in SQL Server

Join Order by SQL Server Query Optimizer

Join Order by SQL Server Query Optimizer

SQL Server DBCC IND Command

SQL Server DBCC IND Command

SQL Server Indexing Architecture – Part 2

SQL Server Indexing Architecture – Part 2

Computing Estimated Operator Cost in SQL Server

Computing Estimated Operator Cost in SQL Server

Viewing Index B-Tree Metadata

Viewing Index B-Tree Metadata

SQL Server Indexing Architecture – Part 1

SQL Server Indexing Architecture – Part 1

Estimated IO Cost

Estimated IO Cost

SQL Server Indexing Question 1

SQL Server Indexing Question 1

LIVE Feedback (SQL Server Performance Tuning Master Class (40 hours))

LIVE Feedback (SQL Server Performance Tuning Master Class (40 hours))

Sample Content (SQL Server Performance Tuning Master Class (40 hours))

Sample Content (SQL Server Performance Tuning Master Class (40 hours))

Compute Scalar Operator and Stream Aggregate in SQL Server

Compute Scalar Operator and Stream Aggregate in SQL Server

End of Month Function in SQL Server

End of Month Function in SQL Server

Find out Top Waits in SQL Server

Find out Top Waits in SQL Server

Multiple Execution Plans for the Same Query

Multiple Execution Plans for the Same Query

SQL Server Index Internals Challenge

SQL Server Index Internals Challenge

SQL Server Memory Usage

SQL Server Memory Usage

Index Union in SQL Server

Index Union in SQL Server

Finding CPU Cost Database-wise in SQL Server

Finding CPU Cost Database-wise in SQL Server

Dynamic Index Seek in SQL Server

Dynamic Index Seek in SQL Server

Reviewing CPU Configuration in SQL Server

Reviewing CPU Configuration in SQL Server

Many Indexes May Hurt Performance

Many Indexes May Hurt Performance

Execution Plan Sort Warning

Execution Plan Sort Warning

T-SQL Tips & Tricks – Part 2

T-SQL Tips & Tricks – Part 2

Partition-Level Locking Performance Technique

Partition-Level Locking Performance Technique

Stats Used by the Query

Stats Used by the Query

Memory Grant Warning in SQL Server

Memory Grant Warning in SQL Server

Query Tuning – What Really Happened

Query Tuning – What Really Happened

Get Parameter Info from Execution Plan

Get Parameter Info from Execution Plan

Ad Hoc Query Caching in SQL Server

Ad Hoc Query Caching in SQL Server

What is Density?

What is Density?

SQL Server High Memory Usage

SQL Server High Memory Usage

Browse Histogram using DBCC SHOW_STATISTICS

Browse Histogram using DBCC SHOW_STATISTICS

FILL FACTOR in SQL Server

FILL FACTOR in SQL Server

SQL Server Top 10 Waits

SQL Server Top 10 Waits

Capture SQL Server Query Execution using Extended Events

Capture SQL Server Query Execution using Extended Events

SQL Server Index Fragmentation

SQL Server Index Fragmentation

WRITELOG Wait Type in SQL Server (The Answer)

WRITELOG Wait Type in SQL Server (The Answer)

SQL Server Indexed Views Performance

SQL Server Indexed Views Performance

High CPU Usage Caused by SQL Server

High CPU Usage Caused by SQL Server

Wait Stats from Properties Window

Wait Stats from Properties Window

WRITELOG Wait Type in SQL Server (The Question)

WRITELOG Wait Type in SQL Server (The Question)

CPU Intensive Queries Currently Running

CPU Intensive Queries Currently Running

Fuzzy String Matching (Query Tuning)

Fuzzy String Matching (Query Tuning)

CPU PERCENTAGE USED by SQL Server Queries

CPU PERCENTAGE USED by SQL Server Queries

Clustering Key Choices (Index Tuning)

Clustering Key Choices (Index Tuning)

SQL Server OS RING BUFFERS DMV

SQL Server OS RING BUFFERS DMV

Troubleshooting SQL Server Plan Cache

Troubleshooting SQL Server Plan Cache

SQL Server Higher Numeric Precision

SQL Server Higher Numeric Precision

Transact SQL Tips & Tricks – Part 1

Transact SQL Tips & Tricks – Part 1

SUBSTRING vs LIKE (Query Tuning)

SUBSTRING vs LIKE (Query Tuning)

SQL Server INSERT Multiple Rows

SQL Server INSERT Multiple Rows

BETWEEN vs IN Operator in SQL Server

BETWEEN vs IN Operator in SQL Server

UPDATE STATS with ROWCOUNT (Query Tuning Trick)

UPDATE STATS with ROWCOUNT (Query Tuning Trick)

SQL Server Thread Quantum Length

SQL Server Thread Quantum Length

SQL Server Plan Cache Fundamentals

SQL Server Plan Cache Fundamentals

TempDB Sort Spilling (SQL Server Query Tuning)

TempDB Sort Spilling (SQL Server Query Tuning)

Finding All User Workloads in SQL Server

Finding All User Workloads in SQL Server

Changing Cost Threshold of Parallelism in SQL Server

Changing Cost Threshold of Parallelism in SQL Server

SQL Server Scheduling Architecture

SQL Server Scheduling Architecture

Dedicated Administrator Connection in SQL Server

Dedicated Administrator Connection in SQL Server

Configuring SQL Server For Better Performance

Configuring SQL Server For Better Performance

No Join Predicate Warning

No Join Predicate Warning

Find plans with warnings

Find plans with warnings

BETWEEN vs IN - Are they the same?

BETWEEN vs IN - Are they the same?

Logical Reads and Physical Reads

Logical Reads and Physical Reads

Join Us - Become a Member

Join Us - Become a Member

Introducing SQL Server Statistics

Introducing SQL Server Statistics

Tempdb Allocations and Deallocations

Tempdb Allocations and Deallocations

Fixing Implicit Conversion

Fixing Implicit Conversion

SQL Server Tempdb Fundamentals

SQL Server Tempdb Fundamentals

Tempdb Multiple Data Files

Tempdb Multiple Data Files

NON-SARGABILITY (Leading Wild Card)

NON-SARGABILITY (Leading Wild Card)

Extracting Query Execution Statistics

Extracting Query Execution Statistics

CPU Time and Elapsed Time

CPU Time and Elapsed Time

Top Five Developer Best Practices

Top Five Developer Best Practices

Optimizer Default Guesstimate

Optimizer Default Guesstimate

Is My Query Running with Multiple Threads?

Is My Query Running with Multiple Threads?

A Practical Introduction to SQL Server Concurrency - Part 2

A Practical Introduction to SQL Server Concurrency - Part 2

Parallelism, Execution Context, Wait Types & Task Level Info

Parallelism, Execution Context, Wait Types & Task Level Info

SELECT TOP 0 CLAUSE

SELECT TOP 0 CLAUSE

Logical Reads vs Physical Reads

Logical Reads vs Physical Reads

WHAT LOCKS ARE TAKEN BY MY TRANSACTION?

WHAT LOCKS ARE TAKEN BY MY TRANSACTION?

Understanding Parallelism in SQL Server

Understanding Parallelism in SQL Server

NOLOCK vs READPAST Lock Hints

NOLOCK vs READPAST Lock Hints

Generate INSERT statements for existing data in a table

Generate INSERT statements for existing data in a table

Top 5 Query Hints A Practical Approach

Top 5 Query Hints A Practical Approach

WHERE vs TOP CLAUSE PERFORMANCE COMPARISON

WHERE vs TOP CLAUSE PERFORMANCE COMPARISON

ORDER BY with TOP 100 PERCENT

ORDER BY with TOP 100 PERCENT

A Practical Introduction to SQL Server Concurrency - Part 1

A Practical Introduction to SQL Server Concurrency - Part 1

CHAR vs VARCHAR – A Simple Performance Story

CHAR vs VARCHAR – A Simple Performance Story

What Is My Query Waiting For?

What Is My Query Waiting For?

What is a Common Table Expression?

What is a Common Table Expression?

SPLIT Window – SQL Server Management Studio Tip

SPLIT Window – SQL Server Management Studio Tip

A Practical Introduction to Extended Events

A Practical Introduction to Extended Events

SQL Server Management Studio Tips & Tricks

SQL Server Management Studio Tips & Tricks

CREATE SCHEMA-ONLY COPY OF TABLE

CREATE SCHEMA-ONLY COPY OF TABLE

SQL Server Wait Types – Let’s Cause One, Diagnose It & Fix It.

SQL Server Wait Types – Let’s Cause One, Diagnose It & Fix It.

SQL Server Interview Questions & Answers – Wait Types

SQL Server Interview Questions & Answers – Wait Types

SQL Server SET STATISTICS TIME IO ON

SQL Server SET STATISTICS TIME IO ON

SQL Server Wait Types – Let’s Cause One, Diagnose It & Fix It

SQL Server Wait Types – Let’s Cause One, Diagnose It & Fix It

Query Tuning – Blocking, Lookup & Indexes

Query Tuning – Blocking, Lookup & Indexes

SQL Server Indexes – Level 2

SQL Server Indexes – Level 2

Scalar Function Death Trap

Scalar Function Death Trap

SQL Server Indexes – Level 1

SQL Server Indexes – Level 1

SQL Server Video Course Bundle

SQL Server Video Course Bundle

What is Parameter Sniffing in SQL Server?

What is Parameter Sniffing in SQL Server?

SQL Server Performance Tuning Master Class Recordings Bundle

SQL Server Performance Tuning Master Class Recordings Bundle

Index Tuning – Memory Grant

Index Tuning – Memory Grant

All-In-One Bundle - SQL Server Video Courses

All-In-One Bundle - SQL Server Video Courses

Query Tuning – Bad TSQL

Query Tuning – Bad TSQL

Index Tuning to Avoid Blocking

Index Tuning to Avoid Blocking

SQL Server Indexes Interview Questions & Answers (Basic - Part 1)

SQL Server Indexes Interview Questions & Answers (Basic - Part 1)

SQL Server Indexing Interview Questions (BASIC-Part 1)

SQL Server Indexing Interview Questions (BASIC-Part 1)

SQL Server CPU Queue & Affinity

SQL Server CPU Queue & Affinity

KILL SQL Server SPID

KILL SQL Server SPID

SQL Server Master Class Recordings

SQL Server Master Class Recordings

How To Stress SQL Server

How To Stress SQL Server

SQL Server Update Statistics with Full Scan

SQL Server Update Statistics with Full Scan

Top 3 SQL Server Tuning Techniques – Part 2

Top 3 SQL Server Tuning Techniques – Part 2

Top 3 SQL Server Tuning Techniques – Part 1

Top 3 SQL Server Tuning Techniques – Part 1

Top 3 SQL Server Tuning Techniques - Part 2

Top 3 SQL Server Tuning Techniques - Part 2

SQL Query Reason For Early Termination

SQL Query Reason For Early Termination

SELECT Query But No Access Method

SELECT Query But No Access Method

Why is the CPU Time more than the Elapsed Time?

Why is the CPU Time more than the Elapsed Time?

How is the Query Cost Derived?

How is the Query Cost Derived?

IO_Completion Wait Type in SQL Server (by Amit Bansal)

IO_Completion Wait Type in SQL Server (by Amit Bansal)

Removing SORT Operator – SQL Server Execution Plans (by Amit Bansal)

Removing SORT Operator – SQL Server Execution Plans (by Amit Bansal)

TSQL TOP Clause Deterministic vs Non-Deterministic (by Amit Bansal)

TSQL TOP Clause Deterministic vs Non-Deterministic (by Amit Bansal)

TSQL WHERE Clause applies after ON Clause (by Amit Bansal)

TSQL WHERE Clause applies after ON Clause (by Amit Bansal)

Monitoring Waiting Tasks (Groups) in SQL Server (by Amit Bansal)

Monitoring Waiting Tasks (Groups) in SQL Server (by Amit Bansal)

SQL Server CPU Queue (by Amit Bansal)

SQL Server CPU Queue (by Amit Bansal)

SQL Server Index Union Operation (by Amit Bansal)

SQL Server Index Union Operation (by Amit Bansal)

SQL Server – Non Clustered Indexes have the Clustering Key (by Amit Bansal)

SQL Server – Non Clustered Indexes have the Clustering Key (by Amit Bansal)

SQL Server – What is my query doing? (by Amit Bansal)

SQL Server – What is my query doing? (by Amit Bansal)

Data Platform Virtual Summit 2022 - You Are Invited

Data Platform Virtual Summit 2022 - You Are Invited

SQL Server Performance Tuning Master Class

SQL Server Performance Tuning Master Class

Non Clustered Indexes may hurt modification queries performance (by Amit Bansal)

Non Clustered Indexes may hurt modification queries performance (by Amit Bansal)

SCAN vs SEEK Performance – What to look for? (SQL Server Query Tuning) (by Amit Bansal)

SCAN vs SEEK Performance – What to look for? (SQL Server Query Tuning) (by Amit Bansal)

SQL Server Query Tuning – What is the execution time? (by Amit Bansal)

SQL Server Query Tuning – What is the execution time? (by Amit Bansal)

SQL Server Order By Clause – Tricky Behavior( by Amit Bansal)

SQL Server Order By Clause – Tricky Behavior( by Amit Bansal)

Query Tuning – Estimates vs Actual Runtime Statistics (by Amit Bansal)

Query Tuning – Estimates vs Actual Runtime Statistics (by Amit Bansal)

Index Usage Stats DMV gets reset (by Amit Bansal)

Index Usage Stats DMV gets reset (by Amit Bansal)

SOS_SCHEDULER_YIELD Wait Type does not show up in Waiting Tasks DMV (by Amit Bansal)

SOS_SCHEDULER_YIELD Wait Type does not show up in Waiting Tasks DMV (by Amit Bansal)

SQL Server Sort Behavior – Basic yet Tricky (by Amit Bansal)

SQL Server Sort Behavior – Basic yet Tricky (by Amit Bansal)

SQL Server Deadlock due to Bookmark Lookup (by Amit Bansal)

SQL Server Deadlock due to Bookmark Lookup (by Amit Bansal)

Deadlock within a single table (by Amit Bansal)

Deadlock within a single table (by Amit Bansal)

Extract Wait Type information from the Execution Plan (by Amit Bansal)

Extract Wait Type information from the Execution Plan (by Amit Bansal)

SPID blocking itself in SQL Server (By Amit Bansal)

SPID blocking itself in SQL Server (By Amit Bansal)

Get the Actual Execution Plan from the Plan Cache (by Amit Bansal)

Get the Actual Execution Plan from the Plan Cache (by Amit Bansal)

Minimize THREADPOOL Wait Type in SQL Server (By Amit Bansal)

Minimize THREADPOOL Wait Type in SQL Server (By Amit Bansal)

Index Seek may not always be Faster (by Amit Bansal)

Index Seek may not always be Faster (by Amit Bansal)

DPS 2021 - Virtual Platform Sneak Preview

DPS 2021 - Virtual Platform Sneak Preview

DPS 2021 Training Classes - Our Awesome Speakers

DPS 2021 Training Classes - Our Awesome Speakers

6 Techniques To Make SQL Server Speedometer Go Past The Speed Limits – Part 2

6 Techniques To Make SQL Server Speedometer Go Past The Speed Limits – Part 2

6 Techniques To Make SQL Server Speedometer Go Past The Speed Limits – Part 1

6 Techniques To Make SQL Server Speedometer Go Past The Speed Limits – Part 1

LIVE Troubleshooting on Production Server – Plan Cache Bloating (by Amit Bansal)

LIVE Troubleshooting on Production Server – Plan Cache Bloating (by Amit Bansal)

LIVE Troubleshooting on Production Server – Physical vs Logical IO (by Amit Bansal)

LIVE Troubleshooting on Production Server – Physical vs Logical IO (by Amit Bansal)

SARGability and Selectivity in SQL Server (by Amit Bansal)

SARGability and Selectivity in SQL Server (by Amit Bansal)

Finding Expensive Lookups in SQL Server (by Amit Bansal)

Finding Expensive Lookups in SQL Server (by Amit Bansal)

Why are Missing Index Hints Missing (by Amit Bansal)

Why are Missing Index Hints Missing (by Amit Bansal)

Developer Best Practices in SQL Server by Amit R S Bansal

Developer Best Practices in SQL Server by Amit R S Bansal

SQL Memory Internals and Troubleshooting by Amit Bansal

SQL Memory Internals and Troubleshooting by Amit Bansal