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
Mar24

SQL SERVER – Does Use of CTE Change the Order of Join in Inner Join

Pinal Dave
SQL Tips and Tricks
CTE, Execution Plan, SQL Joins
1 Comment

A reader said he uses a CTE to control join order. Does a CTE change the order of join in an inner join? Here is what I found.

Continue Reading
Mar23

SQL SERVER – Turning On Graphical Execution Plan After Enabling ShowPlan Text

Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio
No Comments

Turning on graphical execution plan output requires resetting SHOWPLAN and checking the SSMS actual-plan option. These examples explain batch separators, estimated plans, and actual XML output.

Continue Reading
Mar22

Assertion Queries: Data Checks That Should Return Zero Rows

Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL Sub Query, Testing
No Comments

Let a short query find the order with no lines before a customer does. A small demo shows the failing keys, constraint error 547 and a clean repair.

Continue Reading
Mar21

MySQL – Search For Values Within A Comma Separated Values – FIND_IN_SET

Pinal Dave
SQL Tips and Tricks
MySQL
5 Comments

FIND_IN_SET searches a comma-separated string for a complete member and returns its position. I keep whitespace in that string deliberate.

Continue Reading
Mar20

SQL SERVER – Index Fragmentation Next Steps – Notes from the Field #020

Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Index, SQL Server
4 Comments

Indexes get fragmented as data grows. I asked my friend Tim Radney what he does then, and here are his index fragmentation next steps from the field.

Continue Reading
Mar19

SQL SERVER – Retrieve Last Inserted Rows from Table – Question with No Answer

Pinal Dave
SQL Tips and Tricks
MySQL
14 Comments

Can you retrieve the last inserted rows from a table with no identity or date column? Here is my chat with Dustin on a question with no good answer.

Continue Reading
Mar18

Buffer Cache Hit Ratio: Why a Healthy Number Can Lie

Pinal Dave
SQL Tips and Tricks
SQL Cache, SQL Counter, SQL Memory
No Comments

A 99 percent ratio does not mean your memory is fine. Here is how to read the counter correctly and what to check beside it.

Continue Reading
Previous 1 … 441 442 443 444 445 446 447 … 847 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