While I was doing some support cases, I realized that there might be some rows missing from the database for a particular day. So, I took some time off to confirm that indeed there was missing rows from database before I submit a request to DBA to restore the database.
Example: I will try to retrieve missing rows for the date 2013-03-19.
I did the following query to confirm if there was indeed missing rows: