- Jamie is having a problem tracking down an issue users are having with a stored procedure. Users will occasionally have problems with the stored procedure running for an excessive amount of time, perhaps hours on end. There are no messages in the SQL Server error log that correspond to the times that users are having problems. Which of the following is the most likely cause and resolution?
   There is a problem with one or more user connections causing lock contention. Use sp_who and DBCC INPUTBUFFER to track down the likely culprit.

- Jennifer needs to generate a report to list data that is collected and formatted through a view called JenRept. She considers using BCP to output the data from the view, but she doesn’t want to use the awkward command-line utility. Instead she decides to use the BULK INSERT command to create the report.

Evaluate Jennifer’s solution.   This is not a solution to the problem.

- Jesse's company has a central office and three remote locations. Each remote location has three to five employees that run an order-taking application; they don't generate any reports or need any additional data beyond their order-taking application. Each site has a modest but reliable network connection to the central office. Which of the following is the best way for Jesse to provide these users with access to the database?
   Don't use replication; just connect the users directly to the remote database.

- Joe needs to create a standard method for inserting data into several tables. He hasn't decided if he should use a stored procedure or a function, though. Which should he use and why?
   Use a stored procedure because a function cannot be used this way.

- Joe needs to replicate a small amount of data from his server to another server in a remote location. His main server is publishing the data; the remote server is distributing and subscribing to the data. The data is read-only at the remote site. The company brings a new site online with a WAN link directly to the corporate headquarters. What is the best way for Joe to establish replication with the new site?
   Move distribution up to the central office and create a new Subscriber for the new location.

- John needs to write a user-defined function that will return a rowset. The function just needs to take one parameter and use it as a value in the WHERE clause of one SELECT statement. Which type of user-defined function should he use?
   An Inline Table-Valued function