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,847 reads

I’m back from a great vacation. I had the chance to visit two new...

Introduction I was experimenting with vector search in SQL Server 2025 using approximately 3.8...

This is timely, as I’m currently on a boat in the Adriatic taking a...

Comments posted to this topic are about the item Communication, For Incidents and Life

Comments posted to this topic are about the item PostgreSQL psql Meta Commands: Tables

Comments posted to this topic are about the item Building a Support Ticket Triage...

Which of the following psql meta commands (also called backslash or slash commands) will provide information about tables within a database?