A Joes 2 Pros tip on finding apostrophes in string and text: how to search for a single quote with LIKE when a quote also ends the string.
SQL SERVER – Tips from the SQL Development Series – Wildcard – Querying Special Characters – Day 2 of 35
Tips for Querying Special Characters with wildcards, since some symbols are tricky to pattern match. Examples use the [Grant] table in the JProCo database.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Wildcard Basics Recap – Day 1 of 35
A recap of wildcard basics from Joes 2 Pros: how wildcard ranges work with LIKE, explained with a convention registration desk example.
Large IN Lists: When a Temp Table Beats Thousands of Values
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.
Loading Data From an API Into 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.
SQL SERVER – Database Worst Practices
Let us talk about SQL SERVER – Database Worst Practices. Instead of writing best practices, I am going to write about few of the bad ones.
Incremental Loads: Moving Only What Changed
Design an incremental load with reliable boundaries, retained change information, delete handling, and a watermark that advances only after success.