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
SQL SERVER - How to Flip Value of Bit Field in SQL Server?

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

October 25, 2014
Pinal Dave
SQL Tips and Tricks
SQL Scripts

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.

Read More
SQL SERVER - Database Stuck in Restoring State

SQL SERVER – Database Stuck in Restoring State

October 24, 2014
Pinal Dave
SQL Tips and Tricks
SQL Backup and Restore

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.

Read More
Gouache painting of a carved red block beside a strip of cloth printed with a row of identical leaves

Why Use Biml to Build SSIS Packages Faster

October 23, 2014
Pinal Dave
SQL Tips and Tricks
BIML, ETL, Notes from the Field, SSIS

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.

Read More
Gouache painting: a haystack inside a wooden barn with one small vermilion button hidden in the straw, a hanging lantern above it, warm light through the barn slats

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

October 22, 2014
Pinal Dave
SQL Video
Quotes, SQL in Sixty Seconds, SQL Scripts, SQL String

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.

Read More
SQL SERVER - Search Records with Single Quotes - Part 2

SQL SERVER – Search Records with Single Quotes – Part 2

October 21, 2014
Pinal Dave
SQL Tips and Tricks
SQL Scripts

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.

Read More
SQL SERVER - Search Records with Single Quotes

SQL SERVER – Search Records with Single Quotes

October 20, 2014
Pinal Dave
SQL Tips and Tricks
SQL Scripts

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

Read More
Multiple .sql files.

SQL SERVER – Combined Multiple .SQL files into One Single File

October 19, 2014
Pinal Dave
SQL Tips and Tricks
Batch

A friend reading on his phone wanted one file instead of 100s of scripts. I combined multiple .SQL files into one single file from the command prompt.

Read More
Extract domain from email.

EXCEL / SQL SERVER – Extract the Domain from an Email Address

October 18, 2014
Pinal Dave
SQL Tips and Tricks

I took the long route to extract the domain from an email address in Excel by going through SQL Server. This is the simple Excel formula I should have used.

Read More
SQL SERVER - Finding Max Value From Multiple Values

SQL SERVER – Finding Max Value From Multiple Values

October 17, 2014
Pinal Dave
SQL Tips and Tricks

How do you find the max value from multiple values or variables without IF or CASE? A short trick with VALUES and MAX works in SQL Server 2008 and later.

Read More
SQL SERVER - Do You Know Your Data’s Classification? - Notes from the Field #050

SQL SERVER – Do You Know Your Data’s Classification? – Notes from the Field #050

October 16, 2014
Pinal Dave
SQL Performance
Notes from the Field

Tim Radney asks if you know your data’s classification, and explains why data professionals must know what data they hold and how sensitive it is.

Read More
Previous 1 … 285 286 287 288 289 290 291 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

© 2006 – 2026 All rights reserved. pinal @ SQLAuthority.com