I have a Database that is currently 642 GB is size with 317 GB free (49%).
I do not know how it got so large but what would be the best course of action?
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/