Pinal Dave @pinaldave

I am SQL Server Performance Tuning Expert at @SQLAuthority blog.SQLAuthority.com Joined May 2007

Tweets

81K
Followers

27K
Following

473
Likes

1

Pinal Dave @pinaldave

2 weeks ago

🚀 SQL Server Performance: JSON vs XML – The Showdown During a recent consulting engagement, I benchmarked JSON vs XML in SQL Server for real-world data integration scenarios. The results were eye-opening: ✅ Small dataset (3 rows): JSON was 9.8x faster ✅ Large dataset (1,000…

1 2 12 2K 8

Pinal Dave @pinaldave

4 weeks ago

When in doubt, always SELECT the right path!

1 0 10 814 2

Download Image

Pinal Dave @pinaldave

a month ago

CXPACKET waits are not villains. In our latest tuning story we show how 5–10 percent CXPACKET waits meant healthy parallelism. Forcing MAXDOP = 1 killed performance. Discover why in the blog blog.sqlauthority.com/2025/07/25/sql… #SQLAuthority #SQLTips #Parallelism #Database

0 2 6 505 0

Download Image

Pinal Dave @pinaldave

2 months ago

🚀 Heading to Mumbai for a SQL Server Performance Tuning Project! I’ll be traveling to Mumbai during the last week of August and first week of September for a performance tuning engagement. If you're based in Mumbai and have been considering SQL Server Performance Tuning for…

1 0 13 827 2

Download Image

Pinal Dave @pinaldave

2 months ago

I find @pluralsight to be a fun online platform for learning new technologies. I have recently discovered some advanced SQL and PostgreSQL content. What are you learning nowadays?

6 0 10 1K 7

Pinal Dave @pinaldave

3 months ago

0 0 1 591 0

Download Image

Pinal Dave @pinaldave

3 months ago

A query without tuning breathes just fine, But it's a song that lacks its rhyme. The stats are stale, the plan’s unclear— What’s a tune when no one hears? Indexes sleep while CPU cries, TempDB grows, the deadline dies. You call it running—I see a stall. Without the fix, it's not…

0 1 7 716 2

Download Image

Pinal Dave @pinaldave

3 months ago

What did he say?

1 0 2 730 0

Download Image

Pinal Dave @pinaldave

3 months ago

🚨 3 Performance Fixes I Made at a Client Site That Changed Everything 🚨 Sometimes ignorance is bliss—until your system crashes during peak load. I recently worked with a client who said, “We just have one slow report.” What we found was much bigger: a set of silent performance…

2 3 18 986 4

Download Image

Pinal Dave @pinaldave

3 months ago

In May, I worked with a financial organization struggling with performance issues on their SQL Server. One key problem was high PAGEIOLATCH_SH waits, which pointed to slow I/O operations while reading data pages from disk. We traced this to a set of poorly written queries…

0 2 13 917 3

Download Image

Pinal Dave @pinaldave

4 months ago

Performance tuning isn’t a difficult topic—but it’s often seen as intimidating or out of reach. In my consulting session, we’ll break that myth. We’ll cover key tuning concepts step-by-step, and more importantly, you’ll walk away with practical scripts you can apply directly to…