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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

4.79 (138)

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

22,386 reads

You’re invited! I’m thrilled to be co-presenting a session on the top five SQL...

We added a solar system to the ranch as a way to hedge against...

TLDR; The code to do this is below but it’s a bit hokey and...

Comments posted to this topic are about the item Shared Work Spaces: Hell, Heaven,...

Hello, Consider the following table that gives the validity dates of an item :...

Comments posted to this topic are about the item Migrate the SSIS Catalog in...