Maxim Ivashkov
Results
2
issues of
Maxim Ivashkov
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...
Sql server limits number of rows that can be inserted in a single insert to 1000 rows solution enclose the value block into SELECT * FROM ( VALUES (...), (...)...