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
Two boxes joined by an arrow. Phase one, organize, runs SELECT star in three steps that return 4, 7 and 5 rows. Phase two, itemize, swaps the star for a column list and returns the same 5 rows

Build a Query in Two Phases: Organize First, Itemize Second

August 4, 2011
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Coding Standards, SQL Joins, SQL Scripts

Build a query in two phases: organize first, itemize second. Phase one gets the tables, joins and filter working with SELECT *, and phase two swaps the star for a column list. This post shows the method on a small branch and staff table, and the three errors it helps you avoid.

Read More
Table of eight shop names with the character code of each apostrophe and whether LIKE found it. Three straight marks, code 39, were found. Two curly marks, code 8217, were not found

Finding Apostrophes in SQL Server Text: Straight and Curly

August 3, 2011
Pinal Dave
SQL Tips and Tricks
SQL Scripts, SQL Search, SQL String, Unicode

Finding apostrophes in SQL Server text takes one trick and one trap. The trick is doubling the quote inside a LIKE pattern. The trap is that text can hold a curly apostrophe, and the usual search skips it. This post tests both on a table of eight shop names.

Read More
Three LIKE symbols shown as cards: percent sign, underscore and open bracket, each with the number of rows that contain it next to the number of rows LIKE found, and a row of plain symbols whose counts matched

Special Characters in a LIKE Pattern: Which Ones Are Wildcards

August 2, 2011
Pinal Dave
SQL Tips and Tricks
SQL Operator, SQL Scripts, SQL Search, SQL String

Special characters in a LIKE pattern can match the wrong rows, because three symbols mean more than themselves. This post tests every common symbol on one small table. It shows how to search for a percent sign, an underscore and a bracket, and why a space in the pattern counts.

Read More
Four LIKE wildcards with a real example each: percent matches Baker and Brooks for B percent, underscore finds Baker, Patel and Taylor for underscore a percent, [A-K] returns five names, and [^A-K] returns nine

Wildcard Basics in SQL Server: How LIKE Patterns Work

August 1, 2011
Pinal Dave
SQL Tips and Tricks
SQL Operator, SQL Scripts, SQL Search, SQL String

Wildcard basics for SQL Server: how LIKE works with %, _, sets and ranges, shown on one small table of last names. It also covers the mistakes with equal signs and sets, case and accents in ranges, and matching a wildcard literally. Every result comes from SQL Server 2025.

Read More
Tangled fishing flies lie beside matching flies secured individually in a foam fly wallet

Large IN Lists: When a Temp Table Beats Thousands of Values

August 1, 2011
Pinal Dave
SQL Tips and Tricks
Primary Key, SQL Performance, SQL Sub Query, Temp Table

Pasting thousands of IDs into an IN list works, until it does not. See where the time goes and how to keep the answer the same with a temp table.

Read More
Interview

SQL SERVER – The Difficult Interview Question – Moment of the Life – Day 31 of 31

July 31, 2011
Pinal Dave
SQL Interview Questions and Answers

The last day of my interview series is about the difficult interview question: acing an interview is sometimes about personality and reasoning, not only right answers.

Read More
SQL SERVER - Interview Questions and Answers - Guest Post by Jacob Sebastian - Day 30 of 31

SQL SERVER – Interview Questions and Answers – Guest Post by Jacob Sebastian – Day 30 of 31

July 30, 2011
Pinal Dave
SQL Interview Questions and Answers

SQL Server MVP Jacob Sebastian, author of The Art of XSD, adds his own interview questions and answers to the series in this guest post.

Read More
SQL SERVER - Interview Questions and Answers - Guest Post by Feodor Georgiev - Day 29 of 31

SQL SERVER – Interview Questions and Answers – Guest Post by Feodor Georgiev – Day 29 of 31

July 29, 2011
Pinal Dave
SQL Interview Questions and Answers

Feodor Georgiev’s guest post in my interview questions and answers series is part 2 of his take on job interviewing the right way and for the right reasons.

Read More
SQL SERVER - Interview Questions and Answers - Guest Post by Nakul Vachhrajani - Day 28 of 31

SQL SERVER – Interview Questions and Answers – Guest Post by Nakul Vachhrajani – Day 28 of 31

July 28, 2011
Pinal Dave
SQL Interview Questions and Answers

Nakul Vachhrajani’s guest post for my interview questions and answers series starts with what an interview really is and why we all face them.

Read More
A hand pulling the rope of a dumbwaiter hatch as a tray of dishes arrives

Loading Data From an API Into SQL Server

July 28, 2011
Pinal Dave
SQL Tips and Tricks
ETL, JSON, PowerShell, SQL Server

Loading data from an API into SQL Server takes paging, JSON staging, retries, and durable checkpoints so a failed request can resume safely.

Read More
Previous 1 … 409 410 411 412 413 414 415 … 593 Next
  • Books
  • Testimonials
  • Privacy Policy

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