List All Parallel Queries - SQL in Sixty Seconds 098

Pinal Dave

List All Parallel Queries - SQL in Sixty Seconds 098

5 years ago - 2:10

SQL Authority Hub

SQL Authority Hub

@SQLAuthorityHub subscribers

Pinal Dave

Pinal Dave

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 17 years of hands-on experience.

@PinalDaveSQLAuthority subscribers

Who Dropped Your Table? - SQL in Sixty Seconds 112

Pinal Dave

Who Dropped Your Table? - SQL in Sixty Seconds 112

5 years ago - 3:10

Detecting Memory Pressure - SQL in Sixty Seconds 186

Pinal Dave

Detecting Memory Pressure - SQL in Sixty Seconds 186

4 years ago - 2:34

Index SCANs - Good or Bad? - SQL in Sixty Seconds 174

Pinal Dave

Index SCANs - Good or Bad? - SQL in Sixty Seconds 174

4 years ago - 2:21

16 CPU vs 1 CPU : Performance Comparison - SQL in Sixty Seconds 142

Pinal Dave

16 CPU vs 1 CPU : Performance Comparison - SQL in Sixty Seconds 142

5 years ago - 3:31

Most Used Database Files - SQL in Sixty Seconds 190

Pinal Dave

Most Used Database Files - SQL in Sixty Seconds 190

3 years ago - 2:29

List All Sessions - SQL in Sixty Seconds 148

Pinal Dave

List All Sessions - SQL in Sixty Seconds 148

5 years ago - 1:46

Get Memory Details - SQL in Sixty Seconds 165

Pinal Dave

Get Memory Details - SQL in Sixty Seconds 165

4 years ago - 2:02

Single Column Single Row and TABLE SCAN - SQL in Sixty Seconds 111

Pinal Dave

Single Column Single Row and TABLE SCAN - SQL in Sixty Seconds 111

5 years ago - 4:06

Learn SQL Server Vector Basics | Full Tutorial Promo | SQL Authority Hub

SQL Authority Hub

Learn SQL Server Vector Basics | Full Tutorial Promo | SQL Authority Hub

1 month ago - 0:10

Parameter Sensitive Plan optimization - SQL in Sixty Seconds 200

Pinal Dave

Parameter Sensitive Plan optimization - SQL in Sixty Seconds 200

2 years ago - 3:21

Priority Boost and Performance - SQL in Sixty Seconds 131

Pinal Dave

Priority Boost and Performance - SQL in Sixty Seconds 131

5 years ago - 2:15

Forwarded Records and Performance - SQL in Sixty Seconds 155

Pinal Dave

Forwarded Records and Performance - SQL in Sixty Seconds 155

4 years ago - 2:27

Performance Challenge - Write Efficient Query - SQL in Sixty Seconds 140

Pinal Dave

Performance Challenge - Write Efficient Query - SQL in Sixty Seconds 140

5 years ago - 5:53

Live Query Statistics - SQL in Sixty Seconds 104

Pinal Dave

Live Query Statistics - SQL in Sixty Seconds 104

5 years ago - 4:07

Queries Using Specific Index - SQL in Sixty Seconds 180

Pinal Dave

Queries Using Specific Index - SQL in Sixty Seconds 180

4 years ago - 2:06

Optimize for Ad Hoc Workloads - SQL in Sixty Seconds 173

Pinal Dave

Optimize for Ad Hoc Workloads - SQL in Sixty Seconds 173

4 years ago - 1:46

Get CPU Details - SQL in Sixty Seconds 164

Pinal Dave

Get CPU Details - SQL in Sixty Seconds 164

4 years ago - 1:35

COUNT(*) and COUNT(1): Performance Battle - SQL in Sixty Seconds 176

Pinal Dave

COUNT(*) and COUNT(1): Performance Battle - SQL in Sixty Seconds 176

4 years ago - 2:55

COUNT(*) and Index - SQL in Sixty Seconds 175

Pinal Dave

COUNT(*) and Index - SQL in Sixty Seconds 175

4 years ago - 3:01

Stress Testing with oStress - SQL in Sixty Seconds #087

Pinal Dave

Stress Testing with oStress - SQL in Sixty Seconds #087

5 years ago - 2:41

Query Ignoring CPU Threads - SQL in Sixty Seconds 161

Pinal Dave

Query Ignoring CPU Threads - SQL in Sixty Seconds 161

4 years ago - 2:15

Line Numbers for Efficiency - SQL in Sixty Seconds 147

Pinal Dave

Line Numbers for Efficiency - SQL in Sixty Seconds 147

5 years ago - 1:48

Prevent Unauthorized Index Modifications - SQL in Sixty Seconds 183

Pinal Dave

Prevent Unauthorized Index Modifications - SQL in Sixty Seconds 183

4 years ago - 2:40

Efficiency Trick - Query Shortcuts - SQL in Sixty Seconds 143

Pinal Dave

Efficiency Trick - Query Shortcuts - SQL in Sixty Seconds 143

5 years ago - 2:34

Bitwise Puzzle - SQL in Sixty Seconds 160

Pinal Dave

Bitwise Puzzle - SQL in Sixty Seconds 160

4 years ago - 1:21

Avoid Join Hints - SQL in Sixty Seconds 172

Pinal Dave

Avoid Join Hints - SQL in Sixty Seconds 172

4 years ago - 2:18

Performance Comparison - IN vs BETWEEN - SQL in Sixty Seconds 127

Pinal Dave

Performance Comparison - IN vs BETWEEN - SQL in Sixty Seconds 127

5 years ago - 2:22

Index Used for Query - SQL in Sixty Seconds 088

Pinal Dave

Index Used for Query - SQL in Sixty Seconds 088

5 years ago - 1:42

Shutdown SQL Server Via T-SQL - SQL in Sixty Seconds 163

Pinal Dave

Shutdown SQL Server Via T-SQL - SQL in Sixty Seconds 163

4 years ago - 1:32

Infinite Loop - SQL in Sixty Seconds 144

Pinal Dave

Infinite Loop - SQL in Sixty Seconds 144

5 years ago - 1:44

ANSI PADDING and Storage - SQL in Sixty Seconds 210

Pinal Dave

ANSI PADDING and Storage - SQL in Sixty Seconds 210

11 months ago - 2:26

Hide Code in SSMS - SQL in Sixty Seconds 154

Pinal Dave

Hide Code in SSMS - SQL in Sixty Seconds 154

4 years ago - 1:56

Fastest Way to Retrieve Rowcount for a Table - SQL in Sixty Seconds 096

Pinal Dave

Fastest Way to Retrieve Rowcount for a Table - SQL in Sixty Seconds 096

5 years ago - 2:35

Single Installer for SSMS & ADS - SQL in Sixty Seconds 138

Pinal Dave

Single Installer for SSMS & ADS - SQL in Sixty Seconds 138

5 years ago - 1:38

Kick Start! SQL Server 2019 Performance Tips and Tricks

SQLBits

Kick Start! SQL Server 2019 Performance Tips and Tricks

4 years ago - 41:30

Install SQL Server 2019 - SQL in Sixty Seconds 092

Pinal Dave

Install SQL Server 2019 - SQL in Sixty Seconds 092

5 years ago - 2:04

Dirty Read with NOLOCK - SQL in Sixty Seconds 110

Pinal Dave

Dirty Read with NOLOCK - SQL in Sixty Seconds 110

5 years ago - 3:35

Alter Index Add Column - Workaround - SQL in Sixty Seconds 097

Pinal Dave

Alter Index Add Column - Workaround - SQL in Sixty Seconds 097

5 years ago - 1:47

3 Ways to Configure MAXDOP - SQL in Sixty Seconds 166

Pinal Dave

3 Ways to Configure MAXDOP - SQL in Sixty Seconds 166

4 years ago - 1:24