Archive for the ‘Uncategorized’ Category

Terminology in SQL Part 1   Leave a comment

Page – The fundamental unit of data storage in SQL Server

DBCC PAGE – allows you to examine the contents of data and index pages.

DBCC IND – lists of all database pages that make up the selected index or partition.

Data Page – stores data,except text, ntext, image, nvarchar(max), varchar(max), varbinary(max), and xml data, when text in row is set to ON.

Log Files – a series of log records.

Extents – a collection of eight physically contiguous pages and are used to efficiently manage the pages.

.mdf – Primary data file.

.ndf – Secondary data file.

Advertisements

Posted September 9, 2017 by Izharuddin Shaikh in SQL, Uncategorized

Tagged with

Studying and exploring the Architecture…   Leave a comment

Studying and exploring the Architecture modules.

Posted September 6, 2017 by Izharuddin Shaikh in Uncategorized

%d bloggers like this: