I need assistant to make a query only date we have for a month.
I have a db which have data inserted every day at every seconds, so during month end, I need to make sure are all data are inserted. Usually I will run below but this does not tell me if got any date that I missing data in between of min and max.
select min (sm_timestamp),max (sm_timestamp) from MPXLog4 with ( nolock)
2013-10-01 00:00:00.000 2013-10-28 23:59:59.000