Why I avoid Sprocs

Sprocs vs Ad-Hoc is the "el classico" of data access. This post talks in lenght about how sprocs creates more constraints and problems than they actually solve. With maintainance issues, versioning problems, inability to test and other restrictions, sprocs are more of a headache then anything else.