I am going to run an ecommerce website with a huge database (About 10GB). From the replies of my another post, I gathered that I would probably need my own MS SQL 2005 licence instead of subscribing to my host's $25 per 200MB add-on.
So now I am deciding whether to choose VPS or Dedicated.
1. Can I install my own MS SQL 2005 in a VPS?
2. I have no knowledge of running a server. Will this means that I should stick to VPS?
BTW, the database is not so important, so I don't need to have a very secure server.
Definitely should be looking for a manged dedicated server provider. You could check the dedicated server forum and offers for some ideas, then search here to find some reviews. I would look for one that offers Windows as a standard and explain your situation, they should be able to give you some suggestions and optimize the server for you.
Just compare offerings of a few different web hosts and decide whether it is worth to save around $100/month for managed hosting. Having dedicated server only means you'll need to do all the admin work. This takes a lot of time.. a lot!