Practical Reporting Queries with CROSS APPLY (Part 3)

This article continues the series on APPLY, showcasing how some practical reports can be implemented using this operator.

Squared Values

Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server

Learn how the bitwise functions SET_BIT() and GET_BIT() can be used to manage data stored inside a single column.

RegEx Functions II

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 […]