always have at least one active client
 Use char instead of varchar where performance is important
defensive serviceid