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
Oct19

Stored Procedure Execution Count and Average Elapsed Time

Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server, SQL Stored Procedure
4 Comments

To find a stored procedure execution count, query sys.dm_exec_procedure_stats and divide the total elapsed time by the count. This post builds a demo, shows the query, and explains why the numbers start again when a plan leaves the cache. It also fixes the object name lookup that returns NULL for other databases.

Continue Reading
Oct18

SQL SERVER – How to Create Table Variable and Temporary Table?

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL TempDB, Temp Table
5 Comments

A Temporary table uses CREATE TABLE, while a table variable uses DECLARE. I use one row in each beginner example.

Continue Reading
Oct17

Adding Two Dates in SQL Server: Why the Year Is 2126

Pinal Dave
SQL Puzzle
SQL DateTime, SQL Operator, SQL Scripts, SQL Server
29 Comments

Adding two dates in SQL Server does not raise an error. It returns a date in the year 2126. This puzzle explains how datetime counts days from 1900, why the plus sign accepts a second date, and what to write instead.

Continue Reading
Oct16

Run a Stored Procedure at Startup in SQL Server

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Stored Procedure, Starting SQL
2 Comments

To run a stored procedure at startup, create it in the master database and mark it with sp_procoption. This post builds a demo that writes one row every time the instance starts. It also covers the rules, how to check the setting, and how to turn it off again.

Continue Reading
Oct15

Can You DROP Offline Database? – Interview Question of the Week #144

Pinal Dave
SQL Interview Questions and Answers
SQL Scripts, SQL Server
2 Comments

Can you drop offline database in SQL Server? Yes, you can. Many DBAs I interviewed thought otherwise, so here is the full answer.

Continue Reading
Oct14

SQL SERVER – Empty Startup Parameters in SQL Server Configuration Manager

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server, Starting SQL
1 Comment

Configuration Manager showed Empty Startup Parameters when I tried to change the ERRORLOG location in my lab. Here is where they are stored and how to fix it.

Continue Reading
Oct13

SQL SERVER – Msg 1038 – An Object or Column Name is Missing or Empty. For SELECT INTO Statements, Verify Each Column Has a Name

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Scripts, SQL Server
No Comments

Creating a login in SSMS failed with Msg 1038: an object or column name is missing or empty. Profiler showed the real cause. Here is what went wrong.

Continue Reading
Previous 1 … 248 249 250 251 252 253 254 … 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