concurrency
A transaction is a unit of work that you want to treat as "a whole." It has to either happen in full or not at all. A classical example is transferring money from one bank account to another. To
When to use Transactions in SQL Server
When is an appropriate time to use a Transaction? As a follow-up question, if I use them, how can I use them in such a way as to ONLY prevent other SPs from accessing the same data at the same time in
What does a transaction around a single statement do?
BEGIN TRANSACTION / COMMIT "extends" this locking functionality to the work done by multiple statements, but it adds nothing to single statements. However, the database transaction log is
Glossary of Terms and Acronyms
The source is included within each term definition and is indicated in brackets as [source abbreviation]. The specific citation and full name of the source is cited in the Reference List.
How do you clear the SQL Server transaction log?
The transaction log contains a lot of useful data that can be read using a third-party transaction log reader (it can be read manually but with extreme effort though). The transaction log is
NFIRS Incident Types, Actions Taken, Property Use Codes
4.1 Equipment requirements for the emergency response Depending on the size of the emergency operation, additional equipment will be required to support the
Transaction marked as rollback only: How do I find the cause
Participating transaction failed - marking existing transaction as rollback-only So I just stepped through my code to see where this line is generated and found that there is a catch block
FEMA Contracting Desk Guide
Specific authorities, terms and conditions, and file documentation are outlined in the IA award document. A MA is an agreement used to request services/support from Other Federal Agencies (OFA) in
Getting "Lock wait timeout exceeded; try restarting transaction" even
mysql> update customer set account_import_id = 1; ERROR 1205 (HY000): Lock wait timeout exceeded; try restarting transaction I''m not using a transaction, so why would I be getting this error? I
The transaction log for the database is full
I have a long running process that holds open a transaction for the full duration. I have no control over the way this is executed. Because a transaction is held open for the full duration, whe...
Correct use of transactions in SQL Server
Add a try/catch block, if the transaction succeeds it will commit the changes, if the transaction fails the transaction is rolled back:
ERROR: cannot execute CREATE TABLE in a read-only transaction
I was having getting cannot execute CREATE TABLE in a read-only transaction, cannot execute DELETE TABLE in a read-only transaction and others. They all followed a cannot execute