Oky I didn't had idea the service is in production for last 2 year, in 2 year 250MB per customer is nothing 🙂

GUIDs are always unique cross databases but nevertheless...

i am not disagree of the advantages and I know good details how to manage multiple databases but in my books to split the customers data never use multiple databases...

The security issue is not difficult to handle through Stored Procedures and Views. I have experienced the SQL 2005 with 120GB single database for multiple customers with high number of...

Thanks Michael for these suggestions, I will try to find out by verifying the db as you mention.

hi SSCommitted,

I was confussed with Index key for indexes as your index key also take space in the row and effects of total size of the row (I think the...

Thats make sence but what about the Primery Key constrain?