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
Jun13

Shaping Query Results as JSON With FOR JSON PATH

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

Shape FOR JSON PATH output with nested objects, child arrays, null options, and wrappers, then return one complete JSON value to clients.

Continue Reading
Jun12

Azure Data Studio- Export Any SQL SERVER Query As JSON

Pinal Dave
SQL Tips and Tricks
Azure Data Studio, JSON, SQL Server Management Studio
1 Comment

Recently, one of my clients’ Comprehensive Database Performance Health Check asked me if I know a way to export any query as JSON with SSMS.

Continue Reading
Jun11

Year-Over-Year Comparisons in One Query

Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Joins, SQL Reports, SQL Server
No Comments

Build year-over-year monthly comparisons with a complete calendar, LAG, date-aligned joins, safe percentages, and missing-period rules.

Continue Reading
Jun10

QDS_LOADDB Wait: Slow Startup and Query Store Load

Pinal Dave
SQL Performance
Query Store, SQL Server, SQL Wait Stats
3 Comments

A QDS_LOADDB wait means a database waits for Query Store to load its data at startup. This post reads the wait, checks the size of a store, explains the trace flag that loads Query Store asynchronously, and shows the settings that keep a store small.

Continue Reading
Jun9

Give Memory Back to the OS? Why SQL Server Doesn’t

Pinal Dave
SQL Tips and Tricks
SQL Cache, SQL DMV, SQL Memory, SQL Scripts
3 Comments

This is a guest post by Brian Gale. It explains why SQL Server doesn’t give memory back to the OS, what the buffer pool keeps in that memory, and why max server memory needs a realistic value. Two queries show what is held right now.

Continue Reading
Jun8

ORDER BY a Parameter in SQL Server: CASE, Types and Plans

Pinal Dave
SQL Tips and Tricks
SQL CASE, SQL Order By, SQL Scripts, SQL Stored Procedure
7 Comments

To ORDER BY a parameter in SQL Server, write one CASE expression for each column and direction. This post builds the procedure, shows the type conversion and DISTINCT errors that trip people up, measures the cost of the sort that CASE forces, and compares OPTION (RECOMPILE) and dynamic SQL.

Continue Reading
Jun7

How to Find IP Address of All SQL Server Connection? – Interview Question of the Week #280

Pinal Dave
SQL Tips and Tricks
Computer Network, SQL DMV, SQL Scripts, SQL Server
2 Comments

Question: How to Find the IP Address of All SQL Server Connection?

I had recently received this question during a recent consultation.

Continue Reading
Previous 1 … 109 110 111 112 113 114 115 … 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