A Joes 2 Pros tip on dirty records and table hints: what an intermediate record is during a transaction, and how table hints change what you read.
SQL SERVER – Row Constructors – Day 6 of 35
Before SQL Server 2008, 20 rows meant 20 INSERT INTO statements. Row Constructors let you insert them all in one statement. A simple example to try.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Finding un-matching Records – Day 5 of 35
How to find un-matching records, like products that never sold, first with a basic subquery and then with an unmatched records query. A Joes 2 Pros tip.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Efficient Query Writing Strategy – Day 4 of 35
An efficient query writing strategy from Joes 2 Pros: get the easy parts of a complex query working first, so you write it faster with fewer errors.
SQL SERVER – Tips from the SQL Joes 2 Pros Development Series – Finding Apostrophes in String and Text – Day 3 of 35
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.