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
Gouache painting of two nearly identical potted plants on a windowsill with a small vermilion watering can between them.

EDIT_DISTANCE and JARO_WINKLER: Fuzzy String Matching in SQL Server 2025

May 24, 2021
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Scripts, SQL String

EDIT_DISTANCE counts the single-character changes between two strings, and the JARO_WINKLER functions score how alike they look. This post tests the four preview functions on SQL Server 2025, shows the Windows collation error and its fix, and finds near-duplicate customer names.

Read More
Illustrated cover: 3 Memory Checks

SQL SERVER – 3 Queries to Detect Memory Issues

May 18, 2021
Pinal Dave
SQL Performance
SQL DMV, SQL Memory, SQL Scripts, SQL Server

One of the most popular conversations during Comprehensive Database Performance Health Check is about CPU and memory issues.

Read More
Gouache painting of a spinning cog, a block tower and a toy barn with a vermilion door on a shelf

DBCC CHECKIDENT: Check and Fix the Next Identity Value

May 17, 2021
Pinal Dave
SQL Tips and Tricks
SQL Delete, SQL Identity, SQL Scripts, SQL Server DBCC

DBCC CHECKIDENT reports the next identity value of a table and can change it. This post runs NORESEED, the no-option form and RESEED on a small demo table. It shows how DELETE and TRUNCATE treat the counter, the duplicate key error from a value that is too low, and who may run the command.

Read More
Get CPU Details

Get CPU Details – SQL in Sixty Seconds #164

May 14, 2021
Pinal Dave
SQL Video
SQL CPU, SQL in Sixty Seconds, SQL Scripts, SQL Server

I understand that there is no one way to describe the CPUs and that is the primary reason, why I get a different answer when I try to get CPU details.

Read More
Gouache painting of a wooden loom with a cream weaving and a vermilion shuttle trailing red thread

OS Threads by Scheduler in SQL Server: Count Them per CPU

May 7, 2021
Pinal Dave
SQL Performance
SQL CPU, SQL DMV, SQL Scripts, SQL Server

OS threads by scheduler shows how many Windows threads each SQL Server scheduler owns. This post joins the scheduler, worker and thread views and counts them per CPU. It compares the counts with the server totals and explains the hidden schedulers that a careless query counts as CPUs.

Read More
Gouache painting of a shelf of preserve jars with one empty jar and a bare gap holding a vermilion ribbon

Convert Empty String to NULL Date in SQL Server: Use NULLIF

May 6, 2021
Pinal Dave
SQL Tips and Tricks
SQL DateTime, SQL Function, SQL NULL, SQL Scripts

To convert empty string to NULL in a date column, wrap the text in NULLIF before you cast it. A plain CAST returns 1900-01-01 and hides the problem. This post tests five expressions on six text values, including a real 1900 date, a run of spaces and a tab, and shows which ones stay correct.

Read More
Populated, retained and empty receiving drawers remain separate from an outbound case.

SQL SERVER – List Service Broker Queue Count

May 4, 2021
Pinal Dave
SQL Tips and Tricks
Service Broker, SQL Scripts, SQL Server

I inspect Service Broker Queue Count through queue and internal-table catalogs. A customer requested a quick inventory.

Read More
Previous 1 … 14 15 16 17 18 19 20 … 363 Next
  • Books
  • Testimonials
  • Privacy Policy

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