Skip to main content
Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Code code:"if (foo != bar)"
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Saves in:saves
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with
Search options questions only not deleted user 22336

A mechanism for committing a consistent set of changes into a database atomically.

1 vote
2 answers
1k views

run job with uncommitted transaction - how to find the transaction? is it still active?

no locks or blocks are in place, but where is my transaction? … ===================== BEGIN TRANSACTION T1 SET TRANSACTION ISOLATION LEVEL REPEATABLE READ SELECT @@TRANCOUNT BEGIN TRY UPDATE DEStock.DBO.ItemStock SET QtyOnOrder = 0 , DueDate = NULL …
Marcello Miorelli's user avatar
6 votes
1 answer
5k views

Does a single rollback affect all transactions?

When I run the following script: begin transaction select XACT_STATE() select @@TRANCOUNT begin transaction select XACT_STATE() select @@TRANCOUNT begin transaction
Marcello Miorelli's user avatar
4 votes
1 answer
8k views

transaction across multiple databases - what is the overhead?

I run the following update, which is one single transaction across 2 databases. … BEGIN TRANSACTION T1_radhe SET TRANSACTION ISOLATION LEVEL REPEATABLE READ SELECT @@TRANCOUNT BEGIN TRY UPDATE DEStock.DBO.ItemStock SET QtyOnOrder = 0 , DueDate = NULL FROM DEStock.DBO.ItemStock …
Marcello Miorelli's user avatar
1 vote
1 answer
84 views

how can I see how many records have been affected by a transaction before it is committed? o...

I used the following script to disable all other sqlwatch jobs: use distribution set nocount on set transaction isolation level read uncommitted declare @Job_id uniqueidentifier declare @job_name varchar …
Marcello Miorelli's user avatar
1 vote
1 answer
5k views

how to find the name of the distributor server and publisher server from the subscriber serv...

Having in mind that I can add computed columns to the subscription tables according to this link: SQL Server : Transactional Replication Computed Column That I am already doing, and also adding inde …
Marcello Miorelli's user avatar
5 votes
1 answer
3k views

how to identify the transactions that are causing the transaction log to grow?

I have a database of 20 GB which insists in having its transaction log over 7GB. … I have been using the default trace to see when this transaction log has been autogrown, but I found none. …
Marcello Miorelli's user avatar
5 votes
1 answer
1k views

how to kill a rogue spid that is already killed?

I have an obstinate spid that I cannot kill and it is preventing the transaction log of my tempdb to get truncated this is how I found this rogue spid: if object_id('tempdb.. … for over 60 hours: It has already been killed. so the things I have tried doing: alter database sqlwatch set single_user with rollback immediate but it did not work kill 54 with statusonly SPID 54: transaction
Marcello Miorelli's user avatar