Good practice is to use same collation whenever it's possible. If you have databases with different collations on the same sever use COLLATION database_default in CREATE/ALTER TABLE statement to not...
Jim, you are right. SP should give better performance. At least compilation is not needed on server side. But not only performance issue is reason to not write sql in...