Explain the basic concepts of SQL server architecture?
Answer Posted / hari
Sql server is having Physical database & logical database
On Physical Database contians file groups and Transcation
log
in file group Contains data files-36,767 TB
data file contains of tabel -
tabel containts extents
Extents contains Pages
pages Contains rows
Transcation log is Userdefined filegroup by default it's
primary file group
Logical - database objects like
view,Sp,functions,Triggers,Indexes and roles etc
Is This Answer Correct ? | 33 Yes | 10 No |
Post New Answer View All Answers
What is the chart in report?
What are the advantages of having an index on the sql server?
What is temporal data type?
How do I view a stored procedure in sql server?
Explain what are the database objects? : SQL Server Architecture
Can two tables share the same primary key?
Explain filestream storage of sql server 2008?
Can we use custom code in ssrs?
What are the disadvantages of indexes?
what is the different types of backups available in sql server? : Sql server database administration
Do you know sql server 2008 introduces automatic auditing?
Can we insert data into a view?
What is the difference between DATETIME2 and DATETIME?
What is Transparent Data Encryption?
What it means to be triggered?