SQL Server – Transaction log architecture and virtual log files

Here is small effort to explain the architecture of SQL Server transaction log which is depends on log file, Log file is known as write ahead log and capture DML and DDL related information. Whenever any large transaction runs, log file start taking all space on disk, once backup runs log file goes back to ...

SQL SERVER – Understanding of Architecture

SQL Server architecture is collection of components like pages, extents, tables, indexes, query processor and internal memory structure etc. These components works together to maintain data as per customer requirement. Architecture of SQL Server is very big subject to talk, here is small effort to give you understanding and overview of architecture. SQL Server architecture ...