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
Mar7

Remove Cached Plans Not Used for a Set Time in SQL Server

Pinal Dave
SQL Performance
Execution Plan, SQL Cache, SQL Scripts, SQL Server DBCC
3 Comments

To clear cached plans not used for a set time, list the plans by their last execution time or by the time they were built, then clear each one by its plan handle. This post builds a small procedure that previews the plans first and removes them only when you switch it on. It also explains why the plan handle needs its 0x prefix.

Continue Reading
Mar6

SQL SERVER Management Studio – Rebuild All Indexes on Table

Pinal Dave
SQL Tips and Tricks
SQL Index, SQL Scripts, SQL Server, SQL Server Management Studio
13 Comments

SSMS can open a Rebuild All dialog for table indexes. An e-commerce customer discovered this shortcut during my health check.

Continue Reading
Mar5

Count NULLs in a Column in SQL Server: Five Ways Compared

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Group By, SQL NULL, SQL Scripts
6 Comments

To count NULLs in a column, filter with IS NULL and count the rows, or subtract COUNT(column) from COUNT(*). This post tests five ways on 100,000 rows and compares their page reads. It also counts NULLs in several columns at once and shows the NULL group in GROUP BY.

Continue Reading
Mar4

Setup Administrator Rule Failed Even for an Administrator Account

Pinal Dave
SQL Tips and Tricks
SQL Error Messages, SQL Server, SQL Server 2019, SQL Server Installation, SQL Server Security
1 Comment

The Setup administrator rule failed for a client even though they were logged on as an administrator. The setup log showed that sqlsccn.dll could not be loaded. The setup media had files missing, and downloading the media again fixed it.

Continue Reading
Mar3

ANSI_WARNINGS OFF: Why SQL Server Truncates Data Silently

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

With ANSI_WARNINGS OFF, SQL Server cuts a string to fit its column and reports no error. This post runs the same insert with the setting on and off, and shows what else changes: variables, divide by zero and filtered indexes. It also shows how to check which setting a session uses.

Continue Reading
Mar2

SELECT INTO Table Variable: Why It Fails and What to Use

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Table Operation, SQL Variable, Temp Table
1 Comment

SELECT INTO table variable fails with Msg 102 because SELECT INTO creates its target table and a table variable must be declared first. This post shows two working fixes, a declared table variable and a temp table. It also compares them on rollback, dynamic SQL and row estimates.

Continue Reading
Mar1

How to Join Two Tables Without Using Join Keywords? – Interview Question of the Week #266

Pinal Dave
SQL Interview Questions and Answers
SQL Joins, SQL Scripts, SQL Server
8 Comments

Question: How to Join Two Tables Without Using Join Keywords?

Answer: In my life, I have attended many interviews as an interviewer.

Continue Reading
Previous 1 … 123 124 125 126 127 128 129 … 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