In the applicaiton database world I would say the use of surrogate key are very situational and would be one of the latter methods of addressing performance issues.

In the data...