This may be a very basic question but I was wondering, what is best practice between the two following alternatives:
Opening several connections to distinct databases and opening datasets which are tuned to each particular connection (e.g. Select ID from MyTable, cn1).
Opening a single connection and opening all datasets using that connection (e.g. Select ID from DB1.DBO.MyTable, cn).
In other words, what are there performance costs of each?