LogEntryDateTime > .... and  LogEntryDateTime < .... 

select @@version
go
select * from sys.configurations
go

declare @from datetime = '20190101'
      , @to datetime = '20190201'
;

declare @dates table(dt datetime primary key);

while @from <= @to begin

  insert @dates select @from;

  set @from = @from + 1;

end;

select d.dt, t.*
   from @dates as d
        cross apply( select top(1) * from meter_log as t1 where t1.factory_number=:number and t1.type_id=:typeId and t1.modem_id=:modemId and t1.date_format >= d.dt order by t1.date_format asc ) as t

select * from sys.dm_os_sys_info

-- your query
SELECT
	t1.*
FROM meter_log t1
INNER JOIN (SELECT
				MIN(date_format) AS min_time
				FROM meter_log m2
			WHERE factory_number = :number
				AND type_id = :typeId
				AND modem_id = :modemId
				AND (date_format BETWEEN :from AND :to)
			GROUP BY CONVERT(varchar, date_format, 112)
			) t2
	ON t1.date_format = t2.min_time
WHERE t1.factory_number = :number
AND t1.type_id = :typeId
AND t1.modem_id = :modemId

-- alternative 1 
SELECT
	t1.*
FROM meter_log t1
WHERE t1.factory_number = :number
AND t1.type_id = :typeId
AND t1.modem_id = :modemId
and  t1.date_format = (SELECT
                                        MIN(date_format) AS min_time
                                   FROM meter_log m2
                                   WHERE factory_number = :number
                                        AND type_id = :typeId
                                        AND modem_id = :modemId
                                        AND (date_format BETWEEN :from AND :to)
						) 

select * from sys.dm_os_sys_info

select * from sys.dm_os_sys_info

select object_name,counter_name,cntr_value/1024 [MB] 
from sys.dm_os_performance_counters
where counter_name like 'T%Server%Memory%'

exec sp_help meter_log
exec sp_helpindex meter_log
exec sp_spaceused meter_log

exec sp_spaceused meter_log