Questions tagged [transaction]
A mechanism for committing a consistent set of changes into a database atomically.
738
questions
8
votes
2
answers
9k
views
What server property makes TransactionScope escalating to MSDTC?
In our application we're using TransactionScope's. We're aiming to not use the MSDTC service because it's a lot slower than lightweight transactions.
using (var transactionScope = new ...
- 183
6
votes
1
answer
379
views
Does the transaction isolation level affect indices as well?
Here's one for the SQL Server gurus: if I set my SQL Server 2008 transaction isolation level to READ UNCOMMITTED, does that also affect the index pages?
E.g. using ISOLATION LEVEL READ UNCOMMITTED, ...
- 8,902
2
votes
1
answer
3k
views
Save Transaction: Is the name local to the stored procedure or not?
Some foot shooting just occured on a production server. I fixed the problem, but I'm now rather confused.
There is a subset of stored procedures that preserve state on failure. That is, if the ...
- 1,342
13
votes
1
answer
15k
views
Generating Invoices and Tracking
Every 2 weeks, the system will generate the invoices for the companies.
Company will receive an invoice on the 1st and 16th every month. (It will run via Cron Job every 2 week. It scan through the ...
- 319
4
votes
2
answers
3k
views
Oracle 11g see transaction or session start time
I want to know when a session or transaction started. The deadlock file doesn't give me this information. Is there some logfile that keeps these records?
I've got a transaction id "TX-1234-abcd", a ...
- 567
3
votes
2
answers
5k
views
read before write transaction
Talking about transactions (db transactions), does a read operation have always precede a write operation?
That's obvious, isn't it?
Thanks in advance
*Of course my question doesn't take into ...
- 181
0
votes
1
answer
90
views
Transaction question
I have a question.
c stands for Commit, a stands for Abort, T is a transaction (db Transaction)
Is the following sentence true?
either c or a belong to T
In my opinion the sentence is true since ...
- 181
0
votes
1
answer
5k
views
how to make a table unlocked within transaction block
I am using SQL Server 2008. I have several stored procedures that process different reports. Each stored procedure makes use of Begin Transaction' and 'Commit Transaction, using the default ...
13
votes
2
answers
49k
views
SQL Server Transaction Timeout
Is there a way in SQL Server 2008 R2 to cause a timeout for a database modification involving a transaction? We have a scenario where our application code hangs or throws an exception and fails to ...
4
votes
1
answer
2k
views
How to UPDATE just one record in DB2?
In DB2, I need to do a SELECT FROM UPDATE, to put an update + select in a single transaction.
But I need to make sure to update only one record per transaction.
Familiar with the LIMIT clause from ...
- 273
1
vote
1
answer
1k
views
Overlapping Transactions
Apolgies in advance if this has been discussed before, or is even fundamental enough for it to be outlined on, say, Wikipedia. I just felt that asking would be more efficient!
Anyway, I want to ask ...
- 175
1
vote
2
answers
2k
views
SQL Server 2008 R2 - How to check Foreign Key constraints in a transaction only when committed?
We are synchronizing tables between two databases (yes, it needs to be done by our software and not by replication etc.)
Both databases are identical with many foreign-key constraints on tables.
...
- 115
3
votes
1
answer
333
views
Does blocking always mean open transaction?
This may seem a bit dull question but does blocking always mean that there is open transaction and that may cause transaction log grow to infinity because open transaction prevents log truncation (...
- 5,333
6
votes
2
answers
7k
views
Concurrent Transactions vs Simultaneous Transactions
Chapter 6 of David Kroenke's Database Concepts: Database Administration
Is my understanding correct that in a database, simultaneous transactions don't really happen. Instead, it is a concurrent ...
- 61
28
votes
3
answers
16k
views
What is the "Chaos" Isolation level and when should it be used?
ADO.NET documentation shows the possibility of setting the transaction level for a SQL transaction to Chaos. It sounds unpleasant, but if the feature is there, presumably it has some legitimate use.
...
- 382
5
votes
2
answers
2k
views
Find out if two rows came from same transaction in Oracle
I am using Oracle 11.1 and would like to figure out if two rows in one table where inserted by the same transaction.
Is there an easy sql statement to map a row to an transactions id? The table is an ...
- 567
8
votes
2
answers
208
views
Can I use transaction logs to rebuild a database?
We've had some data loss and don't have a reliable backup it seems. We do have HUGE transaction logs and there was some thought that we might be able to use these to get back to a certain point.
Is ...
- 83
9
votes
3
answers
7k
views
SQL Server - what isolation level for non-blocking select statements?
I have a long running transaction (called, say, T1) that performs some deletes, updates and inserts on a table in SQL Server 2008 R2. At the same time, another process periodically runs select ...
- 375
21
votes
5
answers
8k
views
Is ROLLBACK a fast operation?
Is it true that RDBMS systems are optimized for COMMIT operations? How much slower/faster are ROLLBACK operations and why?
- 6,702
4
votes
1
answer
716
views
Locking, deadlocking workaround while process data at the same table
My database has a table: tableX.
Task1 makes intensive INSERTs (1000 records per minute) as records to process and very seldom UPDATEs (1-2 records per minute) as records to recalculate.
At the ...
- 6,702
80
votes
5
answers
82k
views
What risks are there if we enable read committed snapshot in sql-server?
I have read here that some extra data will be stored per row so we might see a performance degradation but what other risks are there?
eg.
Will this affect recovery of the database?
Is there anything ...
- 1,531
4
votes
1
answer
492
views
Is SQL Server Replication transactionally 'safe' across all published tables?
We have a system that has one of its datasources still on SQL Server 2000. In order to achieve higher availability, we are looking to setup transactional replication from this 2000 server to a 2008 ...
- 380
7
votes
1
answer
4k
views
Transaction and data consistency during a failure
When a database begins a transaction, all statements executed in that transaction are isolated and atomic (and consistent and durable). These are pretty much the definition of a transaction.
...
- 6,353
24
votes
1
answer
17k
views
How to use transactions with SQL Server DDL?
I have a login table into which all inserts are done by a single stored procedure.
CREATE TABLE dbo.LogTable(
LogRefnr int IDENTITY(1, 1) NOT NULL,
LogQuery varchar(255) NOT NULL,
LogTime ...
- 12.2k
30
votes
4
answers
126k
views
How to find out who deleted some data SQL Server
My boss had a query from a customer yesterday asking how they could find out who deleted some data in their SQL Server database (it is the express edition if that matters).
I thought this could be ...
- 402
3
votes
1
answer
2k
views
Duplicate UNIQUE KEY error after ROLLBACK in MySQL
I have a table like this
mysql> describe seudonimos;
+--------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra ...
- 33
11
votes
3
answers
9k
views
Will the transaction log shrink automagically in SQL Server?
When SQL Server database in a SIMPLE mode, you don't have to care about the transaction log bakcups. But in a SIMPLE mode, the transaction log seems to grow as it does in FULL mode. Does is truncate ...
- 5,333
2
votes
1
answer
546
views
SQL Server Logon Trigger causing problems with the Distributed Transaction Coordinator
I've created the following simple logon trigger on my SQL Server 2005:
CREATE TRIGGER LOGON_RESTRICTION ON ALL SERVER
FOR LOGON
AS
BEGIN
PRINT 'Hello World'
END
GO
Which seems to be working fine ...
- 123
1
vote
2
answers
5k
views
Distributed Transactions between SQL Server 2000 & MySQL Stopped Working
We have been successfully copying data from a MySQL Slave database into a SQL Server 2000 database. The MySQL server is a linked server. I have tried using v3.51 and v5.1.8 of the ODBC connector ...
- 21
6
votes
7
answers
6k
views
On DB2, who updated a record and what did the record look like before the update?
(SQL Server 2008 R2 Standard, database under full recovery)
I have a table with fields id, firstname, lastname. A statement is executed:
insert into dbo.sometable (id, firstname, lastname) values (1,...
- 61
2
votes
1
answer
3k
views
Is it possible to write an SQL query that automatically reconciles/"transactionalizes" payments and charges
I'm still working on the project mentioned here (http://dba.stackexchange.com/questions/2428/how-do-i-properly-design-a-many-to-many-charges-payments-accounting-system).
The system is to give the ...
- 197
9
votes
3
answers
8k
views
Using MySQL triggers or transactions?
I want to ask your opinion in using MySQL triggers or transactions in a website.
Actually I have a history payment table with - UserId | OperationId | Comment | Credits | Sign (debit or credit). So ...
- 295
25
votes
7
answers
41k
views
Oracle - Any way to view uncommited changes to a particular table?
I'm debugging through a batch process currently that does a lot of DML statements, but doesn't do a commit right away. It would be nice to be able to view the "pending" changes from another session ...
- 411
3
votes
1
answer
366
views
Difference between Flashback Query and Serializable Transaction Mode?
Is there any conceptual difference between a SERIALIZABLE Transaction and a Flashback Query?
- 2,420
3
votes
2
answers
614
views
What is the correct term to describe a "persistent transaction"?
I'm kind of a the administrator of a zero-administration OODBMS, but mostly I do programming.
I remember reading years ago about some SQL database that had a concept of something like a permanent ...
- 181
5
votes
3
answers
1k
views
Deadlock Error from SQL Server 2000 to SQL Server 2008
After migrating data from SQL Server 2000 to SQL Server 2008, when I am doing any a transaction in the table which find out more row on the database, that's gives me error.
Transaction (Process ...
- 1,078
13
votes
2
answers
17k
views
Current isolation level in oracle
How to get the current (default) transaction isolation level in oracle?
- 1,089
5
votes
1
answer
2k
views
Why is this rollback needed when using sp_addextendedproperty in a stored procedure?
In enter link description here I showed, how I document databases.
To insert the extended properties, initially I uses plan sequences of sp_addextendedproperty calls.
But lately I wanted to catch ...
- 12.2k