Search Results
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 |
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 …
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 …
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 …
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 …
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 …
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. …
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 …