Queries

You’ve got one SQL Server hosting a bunch of databases, and performance is bad. Which database should you focus on first?

2019-05-02

Using APPLY to make your queries DRYer

Using the APPLY operator to reduce repetition and make queries DRYer.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(138)

You rated this post out of 5. Change rating

2016-06-10 (first published: 2015-04-02)

22,781 reads

A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...

Every year, the South Carolina State Internal Auditors Association and the South Carolina Midlands...

Data Céilí 2026 Call for Speakers is now live! Data Céilí (pronounced kay-lee), is...

Comments posted to this topic are about the item T-SQL in SQL Server 2025:...

Comments posted to this topic are about the item Your Value from a Conference

Comments posted to this topic are about the item UNISTR Basics

What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)

SELECT UNISTR('Hello 4E16754C') AS 'A Classic';