Evaluating IS NULL vs <> with T-SQL DATETIMEs

Many OR/Ms use an UpdatedAt column and some even use a DeletedAt column for soft deletes. This practice also carries over when using date ranges for controlling notification display (StartDate and EndDate). I’ve often heard many DBAs make the claim that doing a date comparison is faster than checking if the value in a date…
Read More