I recently went for an interview with a software company that claims to write enterprise level software. During the interview, the interviewer remarked that its better to use the database simply to store the data. No stored procedures or triggers (or rather they should be kept to an absolute minimum).
Now I thought that he mentioned this purely from a code maintenance point of view (as described in this PSE question, thanks @gnat), however he mentioned that it was for performance reasons. I know that the company uses C# and MSSQL server for a backend. Is his statement valid and how would the performance be increased by keeping all code logic off the database?