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
Feb26

Aggregate and Detail Columns in One Query: GROUP BY or OVER

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Group By, SQL Scripts, SQL Server
9 Comments

Aggregate and detail columns in one query fail with Msg 8120 until you pick a way to keep the rows. This post compares GROUP BY, a scalar subquery and OVER on one small table, adds PARTITION BY and a share of the total, and then combines GROUP BY with OVER. Every result comes from SQL Server 2025.

Continue Reading
Feb25

Why We Use Code Comments in SQL Server: Say Why, Not What

Pinal Dave
SQL Tips and Tricks
SQL Coding Standards, SQL Documentation, SQL Scripts, SQL Server
4 Comments

Why we use code comments comes down to one habit: write the reason, not the action. This post uses a small library table to show single-line and block comments, commenting out a join to test a theory, the Msg 156 trap, nested comments, and whether comments slow a query. Every result comes from SQL Server 2025.

Continue Reading
Feb24

QUERY_OPTIMIZER_HOTFIXES: Turning On Optimizer Fixes per Database

Pinal Dave
SQL Performance
SQL Performance, SQL Scripts, SQL Server
No Comments

A vendor says to turn on optimizer hotfixes. Here is how I check the setting, try it on one statement, and restore it.

Continue Reading
Feb23

Finding Orphaned Data and Log Files Nobody Attached

Pinal Dave
SQL Tips and Tricks
DBA, Disk, SQL Data Storage, SQL Server
No Comments

Inventory orphaned data and log files by comparing data-folder contents with sys.master_files, then review candidates before cleanup.

Continue Reading
Feb22

SQL SERVER – T-SQL Script to Keep CPU Busy

Pinal Dave
SQL Tips and Tricks
14 Comments

Need to keep CPU busy for capacity planning or stress testing on a development server? I share an improved script, but never run it on production.

Continue Reading
Feb21

SQL SERVER – Shortcut to SELECT only 1 Row from Table

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

Developers often select only 1 row to peek at what a table holds, but typing SELECT TOP 1 again and again is slow. I share a quicker shortcut for it.

Continue Reading
Feb20

Restore a Database in SSMS: Step by Step

Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, SQL Server Management Studio
No Comments

To restore a database in SSMS, right-click Databases, choose Restore Database, pick the backup file, name the destination and choose the recovery state. This post covers each page of the dialog, the tail-log error that stops overwrites, and the T-SQL for a full, differential and log restore chain.

Continue Reading
Previous 1 … 499 500 501 502 503 504 505 … 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