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
CumulativeTotalCalculation

SQL SERVER Challenge – Cumulative Total Calculation

June 16, 2023
Pinal Dave
SQL Interview Questions and Answers
Contest, CTE, Ranking Functions, SQL Scripts, SQL Sub Query

Today we will see a very interesting SQL SERVER Challenge about Cumulative Total Calculation. During a recent Comprehensive Database Performance Health Check.

Read More
Gouache painting of a garage half full of stacked flower pots and half cleared, one stack vermilion

sp_delete_database_backuphistory: Prune msdb Backup History

June 5, 2023
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore, SQL Scripts, System Database

The sp_delete_database_backuphistory procedure removes the backup and restore history of one database from msdb, and sp_delete_backuphistory does it by age. The demo counts the rows of a database before and after the delete and previews the delete by age. The last sections explain how to keep the history small.

Read More
A puppeteer's hands gathering a marionette's loose strings onto one wooden control bar

Finding Permissions Granted Directly to Users Instead of Roles

June 1, 2023
Pinal Dave
SQL Tips and Tricks
DBA, SQL Scripts, SQL Server Security

Find permissions granted directly to users, generate role-based review statements, and preserve DENY, column, and grant-option distinctions.

Read More
A squirrel mid-leap between two oak branches, the branch it slipped from on its first try still swaying.

Agent Job Step Retries: Retry Attempts and Retry Interval

October 11, 2022
Pinal Dave
SQL Tips and Tricks
DBA, SQL Scripts, SQL Server, SQL Server Agent

Configure Agent retry attempts and minute intervals, inspect retry history, and distinguish transient failures from unsafe replays.

Read More
A line of hilltop beacon fires along a coast at dusk, one beacon in the middle dark and unlit.

Heartbeat Gaps: Finding Missing Check-Ins With LAG

June 28, 2022
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL Monitoring, SQL Scripts, SQL Server

Detect missing check-ins with LAG, report closed heartbeat gaps, and find silent or never-seen sources using an explicit UTC tolerance.

Read More
Gouache painting of three hourglasses side by side, the first with grey sand and the other two with vermilion sand

Database File Latency: Read and Write Stalls per IO

June 7, 2022
Pinal Dave
SQL Performance
Disk, SQL DMV, SQL Performance, SQL Scripts

Database file latency is the stall time per read or write. This post divides the IO stall columns by the call counts for every file, explains the zero queued columns and says when a number is worth acting on.

Read More
Gouache painting of a small wooden dollhouse with a closed door and a ring of keys hanging from a vermilion hook

ALTER AUTHORIZATION on a Database: Find and Change the Owner

May 3, 2022
Pinal Dave
SQL Tips and Tricks
SQL Login, SQL Scripts, SQL Server Security

ALTER AUTHORIZATION on a database changes its owner, and SUSER_SNAME(owner_sid) finds the current one. This post shows why a login that owns a database cannot be dropped and how to catch an orphaned owner.

Read More
Previous 1 2 3 4 5 6 7 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com