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

I coach volleyball and I do a lot of stat stuff on paper. I...

dolorblindness – n. the frustration that you’ll never be able to understand another person’s...

I had a customer ask about analyzing their Test Data Manager (TDM) usage to...

Is there a good syllabus for reading these two together? (Yes, it's called the...

Comments posted to this topic are about the item GPX distance and time analysis...

Comments posted to this topic are about the item The DBA is Dead; Long...

In SQL Server 2025, if I want to remove an IP from a listener, what do I do?