- A GOTO command can cause execution of a batch to resume where?
   At a label

- A question on automatic numeric ID's in a table that have to be unique and consecutively added. There was no mention of 'enforced".   Use and IDENTITY int datatype

- Alan has written a complex stored procedure that occasionally has performance problems related to different ranges of parameters passed into the stored procedure. Which of the following tools will help Alan find the combination of parameters without changing any database objects?

Choose all that apply.   Use the SQL Server Profiler to record users who are using his stored procedure with a duration longer than the acceptable duration.

- An UPDATE statement may modify how many tables?
   Only one, though triggers may cause additional side-effects.

- An UPDATE trigger typically accesses which of the following?
   The INSERTED and DELETED tables