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
Apr25

Query Store On or Off for Every Database: Review First

Pinal Dave
SQL Tips and Tricks
Query Store, SQL DMV, SQL Scripts, SQL Server Configuration
No Comments

To turn Query Store on or off for every database, you need one statement per database, because there is no server switch. This post builds a tested script that writes the statements, lets you read them and then runs them in one batch. It also covers READ_ONLY mode and the model database.

Continue Reading
Apr24

Query Store Status for Every Database in SQL Server

Pinal Dave
SQL Performance
Query Store, SQL DMV, SQL Scripts, SQL Server Configuration
4 Comments

Query Store status for every database takes two queries, and the first is not enough. This post builds four demo databases, shows why the is_query_store_on flag hides frozen and read-only states, and runs one script that reads the real state of each database. It also shows what Query Store costs in memory.

Continue Reading
Apr23

SSMS Command Timeout: What the Execution Time-out Does

Pinal Dave
SQL Tips and Tricks
SQL Extended Events, SQL Server Configuration, SQL Server Management Studio, Testing
4 Comments

The SSMS command timeout is the number of seconds a query window waits before it cancels a batch. This post lists the four places a time-out can come from and reproduces a client time-out with sqlcmd and PowerShell. It also shows how an Extended Events session proves that the client gave up.

Continue Reading
Apr22

SSMS ROWCOUNT Setting: Why Your Query Stops at 100 Rows

Pinal Dave
SQL Tips and Tricks
Execution Plan, SQL Performance, SQL Server Configuration, SQL Server Management Studio
2 Comments

The SSMS ROWCOUNT setting limits every query in a window to a fixed number of rows, and it can change the plan as well. This post shows the effect on rows, reads and plan with a tested demo, how to check your own session and why UPDATE statements stop at the limit too.

Continue Reading
Apr21

sp_helpdb in SQL Server: List Databases and Their Files

Pinal Dave
SQL Tips and Tricks
SQL Command, SQL Data Storage, SQL Scripts, SQL Stored Procedure
No Comments

sp_helpdb in SQL Server lists every database on an instance, or the files of one database, with a single call. This post builds three small databases, reads the output column by column and explains why db_size is text. It also shows how to filter the result and how to find free space.

Continue Reading
Apr20

SQL SERVER – Blocking Tree – Identifying Blocking Chain Using SQL Scripts

Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Lock, SQL Scripts, SQL Server
15 Comments

Whenever I end up on a situation where we have lots of blocking issues with my client, I depend on the script of the Blocking Tree.

Continue Reading
Apr19

How to Import a SQL Server Table Inside Excel Sheet? – Interview Question of the Week #273

Pinal Dave
SQL Interview Questions and Answers
Excel
1 Comment

Question: How to Import a SQL Server Table Inside Excel Sheet?

Answer: Well, the answer to this question is pretty straight forward and let us see it today. 

Continue Reading
Previous 1 … 116 117 118 119 120 121 122 … 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