I've seen a recursive CTE get thrown into an infinite loop that also had option (maxrecursion 0). The end result was the query ran until the drive that had TempDB...

Good question, I learned something new.

826 GB

Average backup time 14 Min 7 Seconds

Compression is turned on

I take the train to work, only 22 minutes each way. I use this time to read. I have gotten through over 50 books this year thanks to this reading...

Good question, but I disagree with the explanation to create the view with SCHEMABINDING. This can lead to other issues if the table gets very large. I'm not saying don't...

Good question that made me do a little research and created a good discussion.

This was a good question that makes one really think about null value.

I just found the wording of the question very confusing.

I couldn't disagree more. Our developers are perfectly capable...

As the question is now all five use the nonclustered index. If the table had more data (lots more) then I could see the answer changing.

The (IMHO) much easier to understand (and code) method is by using WHERE NOT EXISTS() which pretty much circumvents all three issues. Ironically it usually ends up with the same...

I didn't read the question until after it was fixed. Having said that, good question. I have never used that is a like statement so I learned something new.

I'll take this one.

Patrick Cahill

I spend the first 10 years of my career working as a translator. While I did enjoy this I have enjoyed the IT field much more. I have now...

Congratulations Jeff, well deserved. I know you went above and beyond in some help you gave me in reviewing an article.