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
Jun13

SQL SERVER – Recovery Models and Selection

Pinal Dave
SQL Performance
SQL Backup and Restore, SQL Coding Standards, SQL Data Storage, SQL Scripts, SQL Server Security
8 Comments

SQL Server offers three recovery models: full, simple and bulk-logged. Here is when to select each one, based on how much data loss you can accept.

Continue Reading
Jun12

Normalization Jokes and the Normal Forms They Make Fun Of

Pinal Dave
SQL Tips and Tricks
Best Practices, Database, Normalization, SQL Humor
3 Comments

Normalization jokes are funny because they are true. Here are the classics in my own words, and the first three normal forms they poke fun at.

Continue Reading
Jun12

SQL SERVER – LEN and DATALENGTH of NULL Simple Example

Pinal Dave
SQL Performance
SQL Function, SQL NULL, SQL Scripts
7 Comments

A common mistake is checking LEN(@var) = 0 for a NULL value. LEN and DATALENGTH of NULL both return NULL, not zero, as this simple example shows.

Continue Reading
Jun11

SQL SERVER – Cannot Resolve Collation Conflict For Equal to Operation

Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Collation, SQL Error Messages, SQL Joins, SQL Scripts, SQL Server
381 Comments

A collation conflict means character expressions use incompatible comparison rules. I choose the intended rules before applying COLLATE.

Continue Reading
Jun11

SQL SERVER – 2005 T-SQL Paging Query Technique Comparison (OVER and ROW_NUMBER()) – CTE vs. Derived Table

Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Joins, SQL Paging, SQL Scripts, SQL Server
29 Comments

Paging in SQL Server 2005 with ROW_NUMBER: CTE vs. derived table. I compare both methods and show they give the same performance for common queries.

Continue Reading
Jun10

SQL SERVER – Retrieve – Select Only Date Part From DateTime – Best Practice

Pinal Dave
SQL Tips and Tricks
Best Practices, SQL DateTime, SQL Function, SQL Scripts, SQL Server
405 Comments

Selecting the date part and formatting it are different tasks. I keep typed dates for calculations and text for display.

Continue Reading
Jun10

SQL SERVER – Fix : Error : An error has occurred while establishing a connect to the server. Solution with Images.

Pinal Dave
SQL Tips and Tricks
Computer Network, SQL Error Messages
13 Comments

An error has occurred while establishing a connection to the server, also known as Error 40, is the top error searched on my blog. Here is the fix in screenshots.

Continue Reading
Previous 1 … 817 818 819 820 821 822 823 … 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