Pinal Dave @pinaldave

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

Tweets

81K
Followers

27K
Following

474
Likes

1

Pinal Dave @pinaldave

2 weeks ago

⚠️ Excel says: “This workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them to get the latest data. Otherwise, you can keep working with the data you have.” 💡 Quick Tip: Press Ctrl+F, search [. External links always show…

0 1 6 2K 2

Download Image

Pinal Dave @pinaldave

a month 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

2 months ago

When in doubt, always SELECT the right path!

1 0 10 833 2

Download Image

Pinal Dave @pinaldave

2 months 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 518 0

Download Image

Pinal Dave @pinaldave

3 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 839 2

Download Image

Pinal Dave @pinaldave

3 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

4 months ago

0 0 1 602 0

Download Image

Pinal Dave @pinaldave

4 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 723 2

Download Image

Pinal Dave @pinaldave

4 months ago

What did he say?

1 0 2 740 0

Download Image

Pinal Dave @pinaldave

4 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 996 4

Download Image

Pinal Dave @pinaldave

4 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…