This month's discount Comprehensive Database Performance Health Check · Testimonials
SQLAuthority with Pinal Dave
Home
  • Consulting
    • Health Check
  • Free Videos
  • All Articles
    • AI
    • SQL Performance
    • SQL Tips and Tricks
    • Interview Questions and Answers
    • SQL Puzzle
    • SQL Video
    • SQLAuthority News
    • Personal
  • Books
  • Consulting
Mar16

Case-Sensitive Search – SQL in Sixty Seconds #158

Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Server, SQL String
No Comments

Earlier I wrote a blog post about SQL SERVER – Case-Sensitive Search. Lots of people said I should make a video on this topic.

Continue Reading
Mar15

Case-Sensitive WHERE Clause: COLLATE Without Losing the Seek

Pinal Dave
SQL Tips and Tricks
SQL Collation, SQL Scripts, SQL Search, SQL Server, SQL String
No Comments

A case-sensitive WHERE clause needs a COLLATE on the comparison, but the obvious version scans the index. A demo measures 286 reads against 2, and shows two fixes: keep the plain test beside it, or give the column a case-sensitive collation.

Continue Reading
Mar12

SQL SERVER – Data and Index Compression – Real-World Conversation

Pinal Dave
SQL Performance
Compression, SQL Index, SQL Scripts, SQL Server
4 Comments

Index Compression needs workload measurements of storage, I/O and CPU. A customer conversation prompted my earlier advice.

Continue Reading
Mar11

Memory-Optimized Tables as a Key-Value Cache

Pinal Dave
SQL Tips and Tricks
In-Memory OLTP, SQL Cache, SQL Memory, SQL Server
No Comments

Build a key-value cache with SCHEMA_ONLY memory-optimized tables, native get and set procedures, expiry checks, and bounded cleanup.

Continue Reading
Mar10

Top Three Wait Stats and What Each One Means

Pinal Dave
SQL Tips and Tricks
SQL CPU, SQL Performance, SQL Server, SQL Wait Stats
No Comments

The top three wait stats in the files people sent in were CXPACKET, SOS_SCHEDULER_YIELD and ASYNC_IO_COMPLETION. A small demo makes each wait happen and measures it with session wait statistics. The post explains what each one means and what to check next.

Continue Reading
Mar9

Wait Stats for Performance – SQL in Sixty Seconds #157

Pinal Dave
SQL Tips and Tricks
SQL in Sixty Seconds, SQL Scripts, SQL Server, SQL Wait Stats
No Comments

I finally decided to create a video on that topic on my SQL in Sixty Seconds Channel. I will create more videos on the topic Wait Stats for Performance.

Continue Reading
Mar8

Waits Since Restart: A Wait Stats Query With Uptime Rates

Pinal Dave
SQL Performance
SQL Scripts, SQL Server, SQL Wait Stats
2 Comments

Waits since restart show where a SQL Server spends its waiting time. One query ranks the real waits, removes the idle ones, and adds the average wait, the signal share and a rate per hour of uptime. A table maps the common waits to the area to check next.

Continue Reading
Previous 1 … 75 76 77 78 79 80 81 … 846 Next

SQL Server slow? Let's fix it together in about four hours.

Pinal Dave

In my Comprehensive Database Performance Health Check, you share your screen, I guide you, and we fix your biggest performance troublemakers. No passwords. No remote access.

You keep every script, and the know-how to fix it yourself next time.

Want your whole team to learn it?

My Practical Workshop has no PowerPoint, just live demos. My AI Enablement Workshop shows your team where AI saves hours, and where it quietly costs them.

Over 400 customers have worked with me this way, and not one shared a password. See all consulting options.


Who We Are

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

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

Pinal is also a CrossFit Level 1 Trainer (CF-L1) and CrossFit Level 2 Trainer (CF-L2).


Nupur Dave is a social media enthusiast and an independent consultant. She primarily focuses on the database domain, helping clients build short and long-term multi-channel campaigns to drive leads for their sales pipeline.


Shaivi Pinalkumar Dave is a book author and a women’s artistic gymnast.

  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com