Pinal Dave

Pinal Dave is an SQL Server Performance Tuning Expert and independent consultant with over 17 years of hands-on experience. He holds a Masters of Science degree and numerous database certifications.

Pinal has authored 13 SQL Server database books and 85 Pluralsight courses. To freely share his knowledge and help others build their expertise, Pinal has also written more than 5,600 database tech articles on his blog at https://blog.sqlauthority.com.

ANSI PADDING and Storage - SQL in Sixty Seconds 210

ANSI PADDING and Storage - SQL in Sixty Seconds 210
SSMS and Execution Timeout - SQL in Sixty Seconds 209

SSMS and Execution Timeout - SQL in Sixty Seconds 209
Performance and TempDB Spills - SQL in Sixty Seconds 208

Performance and TempDB Spills - SQL in Sixty Seconds 208
Deadlock and Profiler - SQL in Sixty Seconds 207

Deadlock and Profiler - SQL in Sixty Seconds 207
TOP vs. Percent: Hidden Costs in SQL Server - SQL in Sixty Seconds 206

TOP vs. Percent: Hidden Costs in SQL Server - SQL in Sixty Seconds 206
CPU Threads and Uneven Workload - SQL in Sixty Seconds 205

CPU Threads and Uneven Workload - SQL in Sixty Seconds 205
Functions and Missing Indexes - SQL in Sixty Seconds 204

Functions and Missing Indexes - SQL in Sixty Seconds 204
3 ChatGPT Tricks to Tune SQL Server - SQL in Sixty Seconds 203

3 ChatGPT Tricks to Tune SQL Server - SQL in Sixty Seconds 203
Deceptive Execution Plan - SQL in Sixty Seconds 202

Deceptive Execution Plan - SQL in Sixty Seconds 202
Function in the WHERE Clause - SQL in Sixty Seconds 201

Function in the WHERE Clause - SQL in Sixty Seconds 201
Parameter Sensitive Plan optimization - SQL in Sixty Seconds 200

Parameter Sensitive Plan optimization - SQL in Sixty Seconds 200
Swap Columns - SQL in Sixty Seconds 199

Swap Columns - SQL in Sixty Seconds 199
Find Database File Latency - SQL in Sixty Seconds 198

Find Database File Latency - SQL in Sixty Seconds 198
Indexing for Delete - SQL in Sixty Seconds 197

Indexing for Delete - SQL in Sixty Seconds 197
Compressed Backup - Performance - SQL in Sixty Seconds 196

Compressed Backup - Performance - SQL in Sixty Seconds 196
3 Important Features - Monitoring Your Database Servers

3 Important Features - Monitoring Your Database Servers
Find Missing Identity - SQL in Sixty Seconds 195

Find Missing Identity - SQL in Sixty Seconds 195
Remove Key Lookup - SQL in Sixty Seconds 194

Remove Key Lookup - SQL in Sixty Seconds 194
Using Stored Procedure in SELECT - SQL in Sixty Seconds 193

Using Stored Procedure in SELECT - SQL in Sixty Seconds 193
5 Questions Answered - Comprehensive Database Performance Health Check

5 Questions Answered - Comprehensive Database Performance Health Check
Performance Troubles - Function on Date Variable - SQL in Sixty Seconds 192

Performance Troubles - Function on Date Variable - SQL in Sixty Seconds 192
Performance: Between and Other Operators - SQL in Sixty Seconds 191

Performance: Between and Other Operators - SQL in Sixty Seconds 191
Most Used Database Files - SQL in Sixty Seconds 190

Most Used Database Files - SQL in Sixty Seconds 190
Optimize DATE in WHERE Clause - SQL in Sixty Seconds 189

Optimize DATE in WHERE Clause - SQL in Sixty Seconds 189
Data Compression for Performance - SQL in Sixty Seconds 188

Data Compression for Performance - SQL in Sixty Seconds 188
Get Current Time Zone - SQL in Sixty Seconds 187

Get Current Time Zone - SQL in Sixty Seconds 187
Обнаружение нехватки памяти — SQL за шестьдесят секунд 186

Обнаружение нехватки памяти — SQL за шестьдесят секунд 186
CPU Running 100% - SQL in Sixty Seconds 185

CPU Running 100% - SQL in Sixty Seconds 185
Generate Script of SQL Server Objects - SQL in Sixty Seconds 184

Generate Script of SQL Server Objects - SQL in Sixty Seconds 184
Prevent Unauthorized Index Modifications - SQL in Sixty Seconds 183

Prevent Unauthorized Index Modifications - SQL in Sixty Seconds 183