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
Apr24

SQL SERVER – Different Methods to Know Parameters of Stored Procedure

Pinal Dave
SQL Tips and Tricks
SQL Stored Procedure
11 Comments

Need to know parameters of stored procedure code quickly? Here are two methods, including sp_help, that list each parameter with its type and order.

Continue Reading
Apr24

SQL Server – Error While Enabling CDC on a Table – The specified ‘@server’ is invalid (valid values are returned by sp_helpserver)

Pinal Dave
SQL Tips and Tricks
Change Data Capture
24 Comments

A reader got an error while enabling CDC on a table: The specified ‘@server’ is invalid. Here is what the message means and what caused it for him.

Continue Reading
Apr23

Hey DBA – Watch Your Vendors! Hey Vendors – Try a Little Harder! – Notes from the Field #077

Pinal Dave
SQL Tips and Tricks
Notes from the Field, SQL Server
No Comments

Notes from the Field #077: Mike Walsh asks every DBA to watch their vendors, and asks vendors to try a little harder. Lessons for both sides.

Continue Reading
Apr22

How to Identify Cross-Database Transactions in SQL Server

Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server, SQL Transactions
6 Comments

To find cross-database transactions, search the code for references to other databases, watch a live transaction with a DMV, or read special records in the transaction log. This post tests all three on two demo databases. It also shows why a popular log script flags a brand new database.

Continue Reading
Apr21

SQL SERVER – Split Comma Separated List Without Using a Function

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

I have shown how to build a comma separated list many times. This time a reader wanted the reverse: split a comma separated list into rows without a function.

Continue Reading
Apr20

Dirty Pages in Memory: Count Them Before and After CHECKPOINT

Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Memory, SQL Scripts, SQL Server Architecture
6 Comments

Dirty pages in memory are changed data pages that SQL Server has not yet written to disk. This post counts them with sys.dm_os_buffer_descriptors on SQL Server 2025, before and after CHECKPOINT, and explains why the same script can show nothing on newer servers.

Continue Reading
Apr19

Interview Question of the Week #016 – How to Take Database Offline

Pinal Dave
SQL Interview Questions and Answers
SQL Scripts
2 Comments

Take a database offline with the right waiting policy, compare detach and SINGLE_USER, and verify SQL Server state before and after.

Continue Reading
Previous 1 … 380 381 382 383 384 385 386 … 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