PWDCompare

Use SQL to Find a String in Database Tables, Stored Procedures, and User Defined Functions

Searching for a string in database tables has been discussed over the years. There are several approaches to the problem (see References at the end of the article). See how to use SQL to find a string in different types of SQL Server objects and data.

Who am I?

The New SQL Server 2025 Data type

The Tightly Linked View

Revisiting SQL Server Window Functions- A Practical Walkthrough

A look at window functions in SQL and how they can be used to query data without the restrictions of a GROUP BY.

How to Increase SQL Server Column Width Without IO (Input/Output) Overhead

This article dives into a fun (and interesting!) strategy for widening fixed-width columns in SQL Server, to reduce downtime, risk, and runtime at the time when a column’s data type needs to be changed.

Tables with a SPARSE Column and Consumption

Using table variables in T-SQL

The Duplicate Cursor