The stuff function in SQL Server is probably one of my favorite functions I’ve worked with simply because of its name. The first time I heard of it I thought my collegue forgot the name of the function they used and said “stuff” as a placeholder.
BOGO Writing SQL and updating SQL databases in R
A Introduction to SQL Joins including left joins, inner joins and full joins
Some tricks I've learned for speeding up queries.
Reminders, tips and tricks for programmers new to SQL and for those who just need a refresh!
What are common table expressions and how can we use them to simplify SQL queries?