Tagged Questions
7
votes
2answers
525 views
Is it a bad practice to always create a transaction?
Is it a bad practice to always create a transaction?
For example, it is a good practice to create a transaction for nothing but one simple SELECT?
What is the cost of creating a transaction when it ...
0
votes
1answer
184 views
Does TRUNCATE TABLE affects isolation level in Sql Server?
As I am working on the project which has SQL SERVER as a database....I'm maintaining isolation level in my project where I enabled snapshot isolation level for my project....
As I have to make some ...
1
vote
1answer
49 views
Does a transaction cover the subroutines?
When I begin transaction and exec a stored procedure, does that transaction cover the changes made by the stored procedure I executed? Would a rollback transaction cancel the changes made by the ...
2
votes
1answer
433 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
vote
1answer
418 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 ...
5
votes
3answers
571 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 ID ...
