Programming options pose dilemma for SQL server users

12.12.2005

Sundial Software Corp. tries to maintain all of its business logic in the application layer, said Ethan Roberts, a software architect at the Madison, Wis.-based IT consulting firm. But database stored procedures built with .Net technologies could minimize network traffic for repetitive operations against a large number of data records, Roberts said. He noted that with the logic in a middle tier, the data would have to cross the network.