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
Oct26

SQL SERVER – How to Flip Value of Bit Field in SQL Server? – Part 2

Pinal Dave
SQL Tips and Tricks
SQL Operator, SQL Scripts, SQL Server
4 Comments

Five expressions flip a bit value in SQL Server without a CASE statement. This post runs Vinod Kumar’s four methods and the readers’ answers on SQL Server 2025, shows what each one returns for 0, 1 and NULL, and explains how to flip value of bit field data stored in an integer column.

Continue Reading
Oct25

SQL SERVER – How to Flip Value of Bit Field in SQL Server?

Pinal Dave
SQL Tips and Tricks
SQL Scripts
1 Comment

How do you flip bit field values from 0 to 1 and back? My favorite method is the ~ operator. Here is a short script that shows it.

Continue Reading
Oct24

SQL SERVER – Database Stuck in Restoring State

Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore
50 Comments

Is your database stuck in restoring state after you restored all backups? RESTORE DATABASE WITH RECOVERY brings it online. I show what to run and when.

Continue Reading
Oct23

Why Use Biml to Build SSIS Packages Faster

Pinal Dave
SQL Tips and Tricks
BIML, ETL, Notes from the Field, SSIS
No Comments

Why use Biml when SSIS already has a designer? This guest post by Reeves Smith shows how one XML file and a single variable can generate many near-identical SSIS packages, and when the extra effort pays off.

Continue Reading
Oct22

Find Rows With Single Quotes in SQL Server: SQL in Sixty Seconds #075

Pinal Dave
SQL Video
Quotes, SQL in Sixty Seconds, SQL Scripts, SQL String
1 Comment

To find rows with single quotes, write the quote twice inside the search string. This post tests four search patterns on one million rows on SQL Server 2025, shows which two are the same query and which one costs more, and covers the curly quote that a straight quote search misses.

Continue Reading
Oct21

SQL SERVER – Search Records with Single Quotes – Part 2

Pinal Dave
SQL Tips and Tricks
SQL Scripts
3 Comments

Readers sent more ways to find records with single quotes: CHAR(39), CHARINDEX and REPLACE. Here are their suggestions, and all of them perform well.

Continue Reading
Oct20

SQL SERVER – Search Records with Single Quotes

Pinal Dave
SQL Tips and Tricks
SQL Scripts
12 Comments

A reader asked how to search records with single quotes in a table column. A simple LIKE query with doubled quotes finds them.

Continue Reading
Previous 1 … 408 409 410 411 412 413 414 … 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