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
A pair of white ice skates on a snowy bench with a loose coil of lace beside them

ZIP Codes Stored as int: Lost Zeros and How to Repair Them

December 10, 2021
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Server, SQL Stored Procedure

An int column turns 01234 into 1234 and never gives the zero back. Here is how to fix the column, and how to repair old rows without guessing.

Read More
Gouache painting: three stands at a dairy loading dock

Scalar Subqueries: An Empty Input Produces NULL

December 6, 2021
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Scripts, SQL Server

Scalar subqueries contribute one value to an outer row. Keep row absence separate from a present NULL and enforce the at-most-one-row contract.

Read More
A sushi rolling mat shaping ingredients outside their original bowls

sp_execute_external_script: Run Python Inside SQL Server

September 22, 2021
Pinal Dave
SQL Tips and Tricks
Best Practices, Python, SQL Server

Before you write any Python, check four switches. Here is how to read them, what error 39023 means, and what to test on your own server.

Read More
A silt core sampler showing a short retained column of layered sediment

Reading the Connectivity Ring Buffer for Dropped Connections

August 19, 2021
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

The error log says nothing, but the connectivity ring buffer may remember. Here is how to read it and what it cannot tell you.

Read More
A rag rug with broad repeated-color bands and distinct color transitions

Status Changes Only: Collapsing Repeated Rows With LAG

July 30, 2021
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Performance, SQL Server

Hundreds of repeated readings, three real changes. Here is how LAG finds them, and why a plain not-equal test quietly drops rows.

Read More
A chain link remover replacing a central connector without discarding attached links

Self-Referencing Foreign Keys: Managers, Employees and Deletes

July 19, 2021
Pinal Dave
SQL Tips and Tricks
Best Practices, SQL Constraint and Keys, SQL Server

Delete a manager and SQL Server says no, which is good. See how to reassign reports safely and how to catch loops the foreign key allows.

Read More
A rope splicing fid separating paired strands before joining a single strand

Line Endings: CHAR(13), CHAR(10) and Files From Other Systems

April 21, 2021
Pinal Dave
SQL Tips and Tricks
Best Practices, Command Line, SQL Server

Why does a value that looks perfect fail a compare? Because of a line ending you cannot see. Five small demos make it visible.

Read More
Previous 1 2 3 4 5 6 7 8 … 55 Next
  • Books
  • Testimonials
  • Privacy Policy

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