Reminder to update statistics
The other day we had a moderate complex query which involved around 270000 rows but…
Null values and their pitfalls
Learning: Best to not permit NULL values in columns which are used for comparisons
Passing comma separated String to function / stored procedure to use with IN condition
[..] passing comma separated variables into a function does not seem to allow the use…
Add leading zeroes to time
When a time is saved as integer the leading zeroes will not be saved.