The READ_COMMITTED_SNAPSHOT database option is set to OFF, and auto-content is set
to ON. Within the stored procedures, no explicit transactions are defined.
If JobB starts before JobA, it can finish in seconds. If JobA starts first, JobB takes a long time to
You need to use Microsoft SQL Server Profiler to determine whether the blocking that you
observe in JobB is caused by locks acquired by JobA.
Which trace event class in the Locks event category should you use?
The Lock:Acquired event class indicates that acquisition of a lock on a resource, such as a data
page, has been achieved.
The Lock:Acquired and Lock:Released event classes can be used to monitor when objects are
being locked, the type of locks taken, and for how long the locks were retained. Locks retained
for long periods of time may cause contention issues and should be investigated.
Note: this question is part of a series of questions that use the same or similar answer choices.
An answer choice may be correct for more than one question in the series. Each question is
independent of the other questions in the series. Information and details provided in a question
apply only to that question.
You are developing an application to track customer sales.
You need to create a database object that meets the following requirements:
- Return a value of 0 if data is inserted successful y into the Customers table.
- Return a value of 1 if data is not inserted successfully into the Customers table.
- Support logic that is written by using managed code.
- Support TRY...CATCH error handling.
What should you create?