SQL Server Interview Questions

Few days back, i went for an interview , following questions were asked * How to Performance Tune a Stored Procedure? * Type of Triggers? * How to get the old value of a field from a trigger when updating a table? * What is the difference between horizontal partition and vertical partition?