When people need to connect publically, those individuals are taking the risk of outside attacks on your server. A year and half ago I noticed that 2 hackers are trying to get into my MS SQL 2008 server via the SA account.
The idea is to perform data cleansing on the Date and Time field from different formats into a unify format such as: YYYYMMDD. Here is a sample data to be used for the data cleansing that I will perform below....
SQL 2012 - Processing hundreds of millions records can be done in less than an hour.
Processing hundreds of millions of records requires a different strategy and the implementation should be different compared to smaller tables with only several millions of records.