Not enough info to make good choices on all, at least for MSSQL. Besides, the correct answer to most database issues is "it depends".