That's right and wrong at the same time. :hehe:

Every modification to a database (in SQL Server) is part of a transaction. Each transaction (which can contain several statements) will be written to the transaction log and will be written to the disk to affect the database when the transaction is committed.

Of course, this is very simplistic, but I'm searching for the full explanation of how this happens.