This article explains the multiple options available to scale out a SQL server database

https://msdn.microsoft.com/en-us/library/aa479364.aspx