ANSWER:
A: SQL Server is optimized to run stored procedures. Complex data operations are best handled by the server. The result set then can be passed to the client, instead of manipulating data on the client.

Answers in Depth...