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
Dec7

TRY_CAST vs CAST: Finding Rows That Will Not Convert Before a Load

Pinal Dave
SQL Tips and Tricks
ETL, SQL Datatype, SQL DateTime, SQL Function, SQL Server
No Comments

Find text values that will not convert before loading, separate invalid and missing input, and use explicit date styles and culture parsing.

Continue Reading
Nov24

INSERT EXEC: Capturing a Procedure’s Result Set and Its Limits

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Stored Procedure, Temp Table
No Comments

Capture rows with INSERT EXEC, match result columns, understand nested and multiple-result limits, and choose supported alternatives.

Continue Reading
Oct31

Approximate Percentiles With APPROX_PERCENTILE_CONT

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Performance, SQL Server, SQL Server 2022
No Comments

Use APPROX_PERCENTILE_CONT for large response-time summaries, compare exact percentiles, and interpret the documented rank error bound.

Continue Reading
Oct26

Finding Schedule Clashes: Overlapping Sessions per Attendee

Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server
No Comments

An attendee says two sessions run at the same time. Here is how to find every overlapping pair once, and why touching is not a clash.

Continue Reading
Oct25

Finding Queries That Spill With total_spills in Query Stats

Pinal Dave
SQL Performance
SQL DMV, SQL Memory, SQL Performance, SQL Server, SQL TempDB
No Comments

Rank total_spills and recent counters, inspect plans, compare Query Store tempdb use, and investigate estimates before increasing grants.

Continue Reading
Oct11

Agent Job Step Retries: Retry Attempts and Retry Interval

Pinal Dave
SQL Tips and Tricks
DBA, SQL Scripts, SQL Server, SQL Server Agent
No Comments

Configure Agent retry attempts and minute intervals, inspect retry history, and distinguish transient failures from unsafe replays.

Continue Reading
Oct10

Session State in SQL Server With Memory-Optimized Tables

Pinal Dave
SQL Tips and Tricks
In-Memory OLTP, SQL Memory, SQL Server, SQL Stored Procedure
1 Comment

Store transient session state in memory-optimized SQL Server tables with native reads and writes, expiry checks, and clear durability rules.

Continue Reading
Previous 1 … 44 45 46 47 48 49 50 … 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