Skip to content
SQL Ocean
  • Home
  • SQL Tutorials
    • Architecture
  • DBA Tutorials
    • Architectures
  • Azure
  • Interview Questions
Menu

SQL Server Log Architecture

  • Post author:Sohel Momin
  • Post published:September 20, 2020
  • Post category:Architecture / Architectures
  • Post comments:0 Comments

The log file is not just that stores information, this is mainly responsible for data consistency. This file stores all the transactions that modify/add data in the database.       Log files has…

Continue Reading SQL Server Log Architecture

SQL Server Page Architecture

  • Post author:Sohel Momin
  • Post published:September 9, 2020
  • Post category:Architecture / Architectures
  • Post comments:0 Comments

The page is the basic building block of storage in SQL server. Data is stored in datafiles (.mdf and .ndf).  Storages are built by group of pages, logically speaking data…

Continue Reading SQL Server Page Architecture

SQL Server Database Architecture

  • Post author:Sohel Momin
  • Post published:September 9, 2020
  • Post category:Architecture / Architectures
  • Post comments:0 Comments

SQL Server database is a logical collection of data. In SQL Server, data is stored in two set of files, Data files and Log files. When we create a database…

Continue Reading SQL Server Database Architecture
  • Home
  • SQL Tutorials
  • DBA Tutorials
  • Azure
  • Interview Questions
© Copyright - www.sqlocean.com 2020
Close Menu