SQL

Stuff Function in SQL

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.

Using R to Program in SQL

BOGO Writing SQL and updating SQL databases in R

SQL Beginner Tips: Joins!

A Introduction to SQL Joins including left joins, inner joins and full joins

Is my query done yet? Tips for Optimizing SQL queries

Some tricks I've learned for speeding up queries.

SQL Tips for Beginners

Reminders, tips and tricks for programmers new to SQL and for those who just need a refresh!

Common Table Expressions in SQL

What are common table expressions and how can we use them to simplify SQL queries?