hi I am Attaching the SQL here FYI,

DECLARE @TranName VARCHAR(20)

SELECT @TranName = 'CSFB_POUpdate'

BEGIN TRANSACTION @TranName

declare @ponum varchar(50),

@serail_num varchar(50),

@msg1 varchar(50)

declare cur_ponum cursor for

select serien_nr,C_PO_Number from vw.komp where serien_nr in (select [Serial...

Hi

I did the following ,

create table Samplein(

F1 char(2),

F2 varchar(10),

F3 varchar(10)

)

inserted records

select * from Samplein

F1   F2         F3        

---- ---------- ----------

AR   Fay        Bob

AR   Fay        John

AR   Fay        Steve

AR   Fay        Chris

TX   Dal       ...

HI

MS SQL Page Faults

PageFaults/Sec Counter

This counter measures the number of physical pages read to (or written to) disk in order to resolve hard page faults.A hard page fault can...

HI,

"However, before writing to disk it will write both the old page and the new page to the transaction log"

This is a very interesting statement...What is before writing to disk.. is...

Hi All,

I have a question on Transaction commit/rollback.

Question

My understanding is that untill a transaction is comitted, the modifications(inserts/updates/deleted) are not made on th disk ( datafiles).