GetEmployee will execute faster than SP_GetEmployee Reason :- Whenever we execute a proc with name having sp_ as prefix, sql server first scans the system procedures. If it does not find the proc in system procedures than it scans the user defined procedures. Hence it takes more time to scan the proc