database – Microsoft DB

SQL Introduction

November 2, 2023November 2, 2023adminLeave a Comment

Large-scale online transaction processing (OLTP), data warehousing, and e-commerce applications are all supported by Microsoft SQL Server. Additionally, it is a business-intelligent platform for reporting, analysis, and data integration. Introduction to Database: Data: A collection of facts, such values or measurements, is called data. It could include of words, numbers, measurements, observations, or just a […]

SQL

November 2, 2023November 2, 2023adminLeave a Comment

which stands for Structured Query Language, is a language used to add, update, and remove data from databases as well as modify the metadata related to those databases. SQL Commands or Types of languages in SQL In order to perform specific data-related tasks, SQL commands are queries sent to the database. Apart from database searches, […]

Storage Architecture

November 11, 2023November 11, 2023adminLeave a Comment

Records->Pages->Extents->Files->Database Pages:The SQL Server page size is 8 KB. This translates to 128 pages per megabyte for SQL Server databases. Each page starts with a 96-byte header that contains system information about the page. This information includes the page number, page type, page size, and the allocation unit ID of the object that owns the […]