Logging

Every database has a transaction log that records all transactions and the database modifications made by each transaction The transaction log is a critical component of the database. If there is a system failure, you will need that log to bring your database back to a consistent state. How that works? What steps SQL Server … Continue reading Logging

How Update works?

Update data in SQL Server is a simple task. Using the command update table set column = value where column = value. Don't forget the where clause :). But, what SQL Server does internally? Delete plus Insert? Modify? Well, the answer depends. Let's see examples how that works. First, create a database and table for … Continue reading How Update works?