In this article, I am going to discuss about the basics of SQL server which is helpful for newbies. SQL–Structured Query Language (pronounced as SEQUEL) is a Database, computer language designed for managing data in relational database management system (RDBMS). Most of the people have to know SQL server query has designed for set based (declarative) . The SQL commands are DQL (Select) DML (Insert, Update, Delete) DDL (Create, Alter, Drop, Truncate) DCL (Grant, Revoke, Deny) TCL (Commit, Rollback) Database A Database stores all the data information (like objects) and has the default data file and log file. The data file is called mdf, ndf…. (One-mdf,more than one…
-
-
sql server internal architecture
Database Physical Structure & Internals: SQL server internals Allocation Map is important for DBAs. It will help to understand the database internals. Database: A Database is a collection of data that is stored (or) organized. We can manage and access data easily. When we create a new database, by default two files will be created physically. We can create more than one log files and data files (NDF). Data file (MDF) Log file (LDF) Data File: All the data will be stored in a data file. Internally the data’s are stored in data pages. A database file has unique FileID and PageID. Log files do not have pages. They have…