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
Dec5

Concat Strings in SQL Server: SQL in Sixty Seconds #035

Pinal Dave
SQL Video
SQL in Sixty Seconds, SQL NULL, SQL Scripts, SQL String
5 Comments

To concat strings in SQL Server, use the + operator or the CONCAT function. The tests here show what each one does with NULL, numbers and dates, how the 8000 character limit cuts a result, and when CONCAT_WS or STRING_AGG is the better tool.

Continue Reading
Dec4

SQL SERVER – Fix: Error : 402 The data types ntext and varchar are incompatible in the equal to operator

Pinal Dave
SQL Tips and Tricks
SQL Error Messages
12 Comments

Error 402 says ntext and varchar are incompatible in the equal to operator. I recreate it with a small table and walk through the possible solutions.

Continue Reading
Dec3

SQL SERVER – Fix Error: Microsoft OLE DB Provider for SQL Server error ‘80040e07’ or Microsoft SQL Native Client error ‘80040e07’

Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Error Messages
2 Comments

Error 80040e07, syntax error converting datetime from character string, usually means a bad date value. In one case a reader had simply misspelled September.

Continue Reading
Dec2

SQL SERVER – Find Referenced or Referencing Object in SQL Server using sys.sql_expression_dependencies

Pinal Dave
SQL Tips and Tricks
SQL DMV, SQL Scripts, SQL Server, SQL Utility
15 Comments

Which tables does a procedure use, and which procedures use a table? sys.sql_expression_dependencies answers both, with referenced and referencing objects.

Continue Reading
Dec1

STRING_AGG Limits: The 8,000 Byte Error, Ordering and Duplicates

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Server, SQL String, SQL XML
2 Comments

Fix STRING_AGG 8,000-byte limits, enforce ordering, remove duplicates before aggregation, and compare its timing with XML.

Continue Reading
Nov30

Why Opening an MDF File Directly Goes Wrong

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

Before you attach MDF file copies, check SQL Server versions, service permissions, and missing files, then choose a safer restore or attach path.

Continue Reading
Nov29

The WINDOW Clause: Name a Window Once and Reuse It

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

Use the WINDOW clause to reuse partition and order rules, extend named windows with frames, and keep SQL Server calculations consistent.

Continue Reading
Previous 1 … 511 512 513 514 515 516 517 … 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