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
Nov27

Efficiency Trick – Query Shortcut – SQL in Sixty Seconds #143

Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Server Management Studio
No Comments

I have built a new SQL in Sixty Seconds video which describes how Query Shortcut works and how we can change them. Let us learn today.

Continue Reading
Nov26

Default Query Shortcuts in SSMS: Alt+F1, Ctrl+1 and Ctrl+2

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

The default query shortcuts in SSMS are Alt+F1, Ctrl+1 and Ctrl+2, and each runs a system procedure on the text you select. This post shows what sp_help, sp_who and sp_lock return, why sp_lock has a better replacement, and which keys you can change.

Continue Reading
Nov25

JOIN Elimination in SQL Server: When a Table Drops Out

Pinal Dave
SQL Performance
Execution Plan, SQL Joins, SQL Scripts, SQL Statistics
1 Comment

JOIN elimination removes a joined table from the plan when the query does not need it. This post proves it with STATISTICS IO, then tests nine variations to show when it applies and when it does not, including a foreign key that has lost its trust.

Continue Reading
Nov24

SQL SERVER – Database Engine TCP Port and Browser UDP Port

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

I inspect TCP listeners to find the actual Network port in use. A customer wanted a query rather than an assumption.

Continue Reading
Nov23

SQL SERVER – Capturing INSERT Timestamp in Table

Pinal Dave
SQL Tips and Tricks
SQL Constraint and Keys, SQL DateTime, SQL Scripts, SQL Server
1 Comment

A default can insert timestamp values when the caller omits a datetime column. I use a session-local CURRENT_TIMESTAMP example.

Continue Reading
Nov20

5 SQL in Sixty Seconds Video on SSMS Efficiency

Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL Server Management Studio
No Comments

I make my living by Comprehensive Database Performance Health Check and one of the constant struggles which I see of my client is to use SSMS Efficiency. 

Continue Reading
Nov19

Custom Query Shortcuts in SSMS: Run Your Own Procedure

Pinal Dave
SQL Tips and Tricks
SQL Server Management Studio, SQL Shortcut, SQL Stored Procedure
No Comments

Custom query shortcuts in SSMS run a stored procedure of your own on the text you have selected. This post writes a small procedure that explains any session, tests it the way the shortcut calls it, assigns it to a free key, and explains which keys you can use.

Continue Reading
Previous 1 … 86 87 88 89 90 91 92 … 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