Timeouts are defined by the connection. You won't find them on the DB server, you need to capture them in the App server which is the one getting the timeouts.

Yet another option.

WITH OnlyTs AS(
  SELECT Date1, LEAD(Date1, 1, '9999') OVER(ORDER BY Date1) NextDate
  FROM #SomeTab
  WHERE Stat = 'T'
)
--SELECT *

Is a 200GB storage or less common for productive db servers? I know that I have a lot more in my laptops which obviously use cheaper storage, but it doesn't...

Something baffles me. You're using 70GB of data between data and indexes.
Why is it so important to recover 6GB when the logic indicates that you'll use it again?...

Remember that you also get points from liked posts. It seems that someone/something is liking random posts according to what I saw on my profile some days ago. With the...

This is an untested version that might help. It only works if you're repeating the exact same CASE clause.

select Salutation,
  case when len(FirstName)= 0 then...

Wine