II have a question on Transaction commit/rollback.
My understanding is that untill a transaction is comitted, the modifications(inserts/updates/deleted) are not made on th disk ( datafiles).
For Example if i am doing a bulk copy of millions of records from a flat file on to sql server table, untill all the records are bulkcopied and transaction completes successfully and a commit is issued explicitly and the data is NOT wriiten to disk, where is the data stored (FOR THAT TRANSACTION)till then?
I mean where is the data stored till the transaction is completed and committed ? This could be really a large data can cache may not b ebig enough to hold this amount of data..?
Please let me know