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
Jun22

LEN vs DATALENGTH: Trailing Spaces, Unicode Bytes and NULL

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

Compare LEN vs DATALENGTH for trailing spaces, Unicode, UTF-8, NULL, and MAX values before safely resizing SQL Server string columns.

Continue Reading
Jun21

SQL SERVER – Storing 64-bit Unsigned Integer Value in Database

Pinal Dave
SQL Tips and Tricks
SQL Datatype
6 Comments

A reader moving from MySQL to SQL Server had a 64-bit unsigned integer column and no matching data type. Here is how I suggest storing that value.

Continue Reading
Jun20

GETDATE vs SYSDATETIME: Precision of the Current Time

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

Compare SYSDATETIME with GETDATE and UTC time functions, understand datetime rounding, and choose a clear timestamp type and clock contract.

Continue Reading
Jun19

Bit Functions in SQL Server 2022: BIT_COUNT, GET_BIT and LEFT_SHIFT

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Operator, SQL Server, SQL Server 2022
No Comments

Use BIT_COUNT and SQL Server 2022 bit functions to read, set, count, and shift flags, while choosing clear storage for ordinary settings.

Continue Reading
Jun18

What to Look For in a SQL Client Tool

Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server
3 Comments

Choose a SQL client tool by testing result handling, execution plans, transactions, and connection identity before trusting it with real work.

Continue Reading
Jun17

What Is a Trigger in SQL Server?

Pinal Dave
SQL Tips and Tricks
Best Practices, Database, SQL Scripts, SQL Server
4 Comments

A trigger in SQL Server runs because something else happened, and you never call it. The inserted and deleted tables, why it fires once per statement and not once per row, and when to reach for something else.

Continue Reading
Jun16

Cosine, Euclidean or Dot: Picking a Vector Distance Metric

Pinal Dave
SQL Tips and Tricks
AI, Mathematics, SQL Server
No Comments

Cosine, Euclidean and dot can rank the same vectors differently. Here are tiny examples you can check by hand, plus how to choose.

Continue Reading
Previous 1 … 482 483 484 485 486 487 488 … 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