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
May31

geometry STUnion: Merge the Shared Area Only Once

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

geometry STUnion merges geometry coverage. These exact-coordinate rectangles distinguish a combined area from the sum of two areas, including duplicate coverage.

Continue Reading
May30

REGEXP_INSTR: Locate a Match or a Capture Group

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

REGEXP_INSTR returns the position of a selected regular-expression match or capture group. I compare its positional arguments using one short string. This example needs SQL Server 2025 and database compatibility level 170.

Continue Reading
May29

SQL Error Riddles: Parent Keys Not Found and Other Classics

Pinal Dave
SQL Tips and Tricks
Primary Key, SQL Constraint and Keys, SQL Error Messages, SQL Humor
No Comments

SQL error riddles have been passed around for years. Here are the classics, told kindly, with the real SQL Server error behind each punchline.

Continue Reading
May28

SQL SERVER – Disabled Index and Update Statistics

Pinal Dave
SQL Performance
SQL Index, SQL Scripts, SQL Server, SQL Statistics
3 Comments

A reader asked how disabled indexes affect statistics. With the clustered index disabled, Update Statistics throws an error; see what happens once you enable it.

Continue Reading
May27

SQL SERVER – DATE and TIME in SQL Server 2008

Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Scripts, SQL Server
21 Comments

What happens when you convert DATE and TIME in SQL Server 2008 to DATETIME? A quick demo shows the midnight and 1900 surprise.

Continue Reading
May26

SQLAuthority News – SQL Server Technology Evangelists and Evangelism

Pinal Dave
SQLAuthority News
MVP
8 Comments

Am I an evangelist, a mentor or a founder? A funny talk from my public training about SQL Server Technology Evangelists and what my title really is.

Continue Reading
May26

Estimated and Actual Execution Plans

Pinal Dave
SQL Performance
Execution Plan, SQL Performance, SQL Server Management Studio, SQL Statistics
No Comments

Estimated and actual execution plans answer different questions; compare compiled choices with runtime rows, warnings, and resource use.

Continue Reading
Previous 1 … 650 651 652 653 654 655 656 … 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