Adding new column with DEFAULT

How to avoid nested REPLACE functions with TRANSLATE in SQL Server

This guide covers how TRANSLATE() works, how it compares to REPLACE(), and where it falls short compared to other SQL dialects like PostgreSQL and Oracle.

Randomly Selecting Columns and Rows from a Table or View

The following script creates a procedure that returns a specified number of random columns and rows from a specified table or view. The number of columns and rows is determined by the @NumberOfColumns and @Rows parameters. The @RandomColumnOrder parameter specifies whether the selected columns are returned in random order or sorted by their ordinal position […]

sp_TexasHoldEm: Multi-Player Poker in T-SQL

Wanna play some Texas Hold ‘Em style poker and make a pile of Query Bucks? Wanna watch other database people playing?

RegEx Functions I

The memory toll of VARCHAR(MAX) in SQL Server

Introduction When designing the tables or writing the stored procedures in SQL Server, we get easily tempted to choose the path of least resistance. When deciding how much space to allocate for a text column in a database table which may contain the description of a product, a product name, or an additional comment/remarks, it […]

BIT_COUNT() V

OUTER APPLY Fundamentals: Part 2

In Part 2 of this series we learn how OUTER APPLY can be used in your queries to return data, even when there are no matches between tables.

The Range of Customers

Escaping Strings