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

Redgate recently released SQL Compare v16, which included a new feature to work with...

I was listening to the radio the other day and the hosts were discussing...

We’re a week late, once again my fault. I was still coming out of...

Comments posted to this topic are about the item What is Page Density

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

Looking to confirm my understanding of these three products and how they can be...

In SQL Server, there is a concept of page density. This is determined by how much data is stored on each page. What is a page density of 90%?