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
Jan17

COALESCE Fallbacks: Empty Text Is Still a Supplied Value

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

COALESCE fallbacks keep empty text and spaces as supplied values. Apply an empty-value policy before choosing a display name.

Continue Reading
Jan16

Auditing Who Has sysadmin

Pinal Dave
SQL Tips and Tricks
DBA, SQL Audit, SQL Login, SQL Server Security
No Comments

Audit who has sysadmin in SQL Server, including direct members and Windows groups, then investigate nested access and forgotten logins.

Continue Reading
Jan15

SQL SERVER – What is – DML, DDL, DCL and TCL – Introduction and Examples

Pinal Dave
SQL Tips and Tricks
Database
170 Comments

What are DML, DDL, DCL and TCL? A short introduction to the four groups of SQL commands, with examples like SELECT, CREATE, GRANT and COMMIT.

Continue Reading
Jan14

SQL SERVER – Time Out Due to Executing DELETE on Large RecordSet

Pinal Dave
SQL Performance
SQL Scripts
5 Comments

Why does a DELETE on large recordset time out? When you want every row gone, use TRUNCATE instead, but keep in mind it resets the identity value.

Continue Reading
Jan13

Conditional COUNT: ELSE 0 Counts Nonmatching Rows

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

Conditional COUNT includes zero when CASE returns it. I compare an omitted ELSE with a zero branch before aggregating. A no-match group and an empty input expose the difference from SUM.

Continue Reading
Jan12

SQL SERVER – 2005 – Change Compatibility Level – T-SQL Procedure

Pinal Dave
SQL Tips and Tricks
Compatibility Level, SQL Scripts
15 Comments

The safe way to change compatibility level in SQL Server 2005: single user mode, sp_dbcmptlevel, then multi user again, and how to check it.

Continue Reading
Jan11

SQL SERVER – Reclaim Space After Dropping Variable – Length Columns Using DBCC CLEANTABLE

Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Server, SQL Server DBCC, SQL System Table
8 Comments

DBCC CLEANTABLE can reclaim selected space left after dropping variable-length columns. I distinguish that table operation from shrinking a database file.

Continue Reading
Previous 1 … 780 781 782 783 784 785 786 … 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