problem: extra size/performance issues due to convert for datetime
solution
explicit conversion for date or datetime is unnecessary,
instead of convert(datetime,'2020-01-01 00:00',121) , there should be just '2020-01-01 00:00'.
sql server does perfect job in converting datetime if value strings are in sql server date format
problem: extra size/performance issues due to convert for datetime
solution
explicit conversion for date or datetime is unnecessary,
instead of convert(datetime,'2020-01-01 00:00',121) , there should be just '2020-01-01 00:00'.
sql server does perfect job in converting datetime if value strings are in sql server date format