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
Feb14

Report Caching and Snapshots in SSRS

Pinal Dave
SQL Performance
Reporting Services, SQL Cache, SQL Reports, SQL Server
No Comments

Report caching and snapshots in SSRS reduce repeated database work when freshness rules, parameter combinations, and schedules are clear.

Continue Reading
Feb13

Backing Up SQL Server Express Without Agent

Pinal Dave
SQL Tips and Tricks
DBA, SQL Backup and Restore, SQL Server Express, sqlcmd
No Comments

Backing up SQL Server Express requires a BACKUP script, sqlcmd, Windows Task Scheduler, retention rules, and proof that restores work.

Continue Reading
Feb12

UPDATE With a JOIN: Changing Rows From Another Table Safely

Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Joins, SQL Server, SQL Transactions
No Comments

Use UPDATE with a JOIN safely, reject duplicate source keys, compare subquery and MERGE behavior, and verify the affected rows.

Continue Reading
Feb11

SQL SERVER – ALTER DATABASE dbname SET SINGLE_USER WITH ROLLBACK IMMEDIATE

Pinal Dave
SQL Tips and Tricks
SQL Scripts
22 Comments

Cannot drop a database because it is in use? SET SINGLE_USER WITH ROLLBACK IMMEDIATE rolls back open work first. Be careful with it on production.

Continue Reading
Feb10

STRING_SPLIT and Its Ordinal Column

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Server, SQL Server 2022, SQL String
1 Comment

STRING_SPLIT and its ordinal column preserve token positions when you request the third argument and sort by ordinal in SQL Server.

Continue Reading
Feb9

smalldatetime: Minute Rounding Can Change the Day

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

smalldatetime does more than hide seconds. These explicit conversions show minute rounding and a midnight carry, with complete original timestamps retained.

Continue Reading
Feb8

SQL SERVER – Find the Size of Database File – Find the Size of Log File

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL System Table, Transaction Log
57 Comments

A quick script on sys.master_files to find the size of database file and log file in MB. Remove the WHERE clause to see every database on the server.

Continue Reading
Previous 1 … 666 667 668 669 670 671 672 … 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