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
Dec8

Change Database and Table Collation – SQL in Sixty Seconds #145

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

I discussed the method to change the database and table collation with my client during the Comprehensive Database Performance Health Check.

Continue Reading
Dec7

Slowest Cached Queries in SQL Server: Time, Reads and Plan

Pinal Dave
SQL Performance
Execution Plan, SQL DMV, SQL Scripts
10 Comments

To find the slowest cached queries in SQL Server, rank each statement by its average elapsed time and keep its plan beside it. This post builds a small workload, reads sys.dm_exec_query_stats with the plan, and shows why a database filter on the sql text hides every ad hoc query.

Continue Reading
Dec4

sp_updatestats and Disabled Indexes: What Gets Updated

Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Statistics
No Comments

sp_updatestats and disabled indexes: the procedure updates statistics on disabled nonclustered indexes and skips a table whose clustered index is disabled. This post proves both, times the cost of disabled indexes against dropped ones on a million rows, and generates a targeted update that skips them.

Continue Reading
Dec3

Top N Plus Others: Grouping the Rest Into One Row

Pinal Dave
SQL Tips and Tricks
Ranking Functions, SQL Group By, SQL Scripts, SQL Server, SQL Top
No Comments

Create top N plus others summaries with deterministic category ranking, one remainder total, stable labels, and explicit display ordering.

Continue Reading
Dec2

Infinite Loop – SQL in Sixty Seconds #144

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

Lots of people wrote feedback about it and wanted me to explain in this video so I have built this new Video where I discuss Infinite Loop.

Continue Reading
Dec1

SQL SERVER – Change Database and Table Collation

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

To Change Database collation, I separate its default from existing character-column settings. The customer moved from case-insensitive to case-sensitive behavior.

Continue Reading
Nov30

WHILE 1 = 1 Loop in T-SQL: Run Forever, Stop Safely

Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Scripts, SQL Server
1 Comment

A WHILE 1 = 1 loop never ends on its own, so every one needs a planned exit. This post builds a once-a-second sampler with three ways out, a stop flag, a round limit and a time limit, then shows how to stop a loop from a second window and what the recursion limit does.

Continue Reading
Previous 1 … 85 86 87 88 89 90 91 … 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