The other day we had a moderate complex query which involved around 270000 rows but run for over an hour. After updating the statistics the …
Learning: Best to not permit NULL values in columns which are used for comparisons
[..] passing comma separated variables into a function does not seem to allow the use of the variable directly in the IN condition.
When a time is saved as integer the leading zeroes will not be saved.