• Think of each database as a service. A given service has a contract that says for these inputs, you get these outputs. With that in mind, any given access mechanism for a database is stored with that database (until and unless we're talking ORM-style coding, different discussion entirely). It makes perfect sense from a coding standpoint and follows traditional coding best practices. In fact, that makes more sense than the other approach.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning