.Net and Xamarin Development

The following line of SQl statement will return the file size for SQL server database log file size and database file size select file_id, type, name, physical_name, size, max_size  from master.sys.database_files The following are the file size  1 0 master D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf   32000 -1 2 1 mastlog D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf   24960 -1 Note: The file size is calculate as  32000*8 /1000 = 256MB

It looks that Arvixe is a pretty good Windows Hosting provider from reviews of following website. http://www.webhostingjury.com/reviews/Arvixe and http://www.webhostingstuff.com/review/ArvixeWebSolutions.html This is the link for Arvixe web hosting

I have purchase GoDaddy unlimited plan about one year ago. For most of the last year, every thing works fine, as all I need is just one SQL Server database with less than 1GB disk space. GoDaddy is pretty happy, and I am happy too. However, 20 days ago I started to need more SQL server databases because 200MB per database is not enough. Therefore I created a system that can split the data into multiple databases and query against multiple database when necessary and do the data paging from my code side instead of using SQL Server Stored Procedure. I created 800 hundred SQL Server databases to fit my structure, which takes quite a little while because GoDaddy does not provide permission to create database using DBML. I manually created all these databases one by one. Kind of pain but still acceptable. Since it is so time consuming to create these databases and create c# code to manage these databases, I decided to pay and buy a few more years unlimited hosting plan to make sure at le...