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
Nov7

Window Functions Over GROUP BY Results: SUM of SUM Explained

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

Why does SUM(SUM(Amount)) OVER () work? Because the window runs after GROUP BY. A short demo with shares, ranks and a filter trap.

Continue Reading
Nov6

Ordering a Maintenance Window: Backups, CHECKDB and Index Work

Pinal Dave
SQL Tips and Tricks
DBA, Maintenance Plan, SQL Backup and Restore, SQL Index, SQL Server DBCC
No Comments

Order a maintenance window by listing Agent schedules, separating CHECKDB, backups, index work, and statistics, then tracking growth.

Continue Reading
Nov5

SQLAuthority News – #SQLPASS 2012 Seattle Update – Memorylane 2009, 2010, 2011

Pinal Dave
SQLAuthority News
SQL PASS
2 Comments

The first day of SQLPASS 2012 in Seattle, and a trip down memory lane: the city I never managed to visit as a student, and my PASS trips of 2009 to 2011.

Continue Reading
Nov4

Find SQL Server Agent Job Failures Before Users Do

Pinal Dave
SQL Tips and Tricks
DBA, SQL Monitoring, SQL Scripts, SQL Server Agent
No Comments

Agent job failures hide in msdb until someone reads the history. This post builds three demo jobs, then finds the failed step and its message, the job that runs too long, the job that never starts, and the jobs that notify nobody.

Continue Reading
Nov3

Walking Foreign Key Chains to Find a Safe Delete Order

Pinal Dave
SQL Tips and Tricks
CTE, SQL Constraint and Keys, SQL Delete, SQL Server
2 Comments

Map foreign key chains from a parent table with a recursive catalog query, then list deepest children first and flag cascade rules.

Continue Reading
Nov2

SQL SERVER – Function to Round Up Time to Nearest Minute Interval

Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Scripts, SQL Server
26 Comments

A small T-SQL function that rounds a datetime up or down to the nearest minute interval you pass in, with the code and how to call it.

Continue Reading
Nov1

Identity Overflow Check: How Close Is Each INT Column to 2,147,483,647

Pinal Dave
SQL Tips and Tricks
SQL Identity, SQL Scripts, SQL Server
1 Comment

A table with few rows can still be one insert away from error 8115. Here is a check that shows the real headroom of every INT identity column.

Continue Reading
Previous 1 … 515 516 517 518 519 520 521 … 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