Did you say denormalize, why?

How to display data from 1-to-many in a single record!

NOT BETWEEN

Find Customers Who Bought "A" and "B" But Not "C" (SQL Spackle)

A simple problem that can become complex in T-SQL. How do you find the rows that match 2 conditions, but not a third, in an efficient manner. MVP Jeff Moden gives us a solution.

Dealing with custom date formats in T-SQL

Should I be formatting dates on the database side? What tools can I use in SQL Server to format and parse dates? This article helps you decide which one best suits your needs.

SOME

Looping

Large table cleanup with minimal locks

How do you delete millions of rows with minimal impact to the business? This article gives you a way to accomplish the removal of old data.

Split Function to break the Job History Message into a Table

Split Function for T-SQL Server to break the Job History Message into Table.

BETWEEN

Not In