Explain the basic concepts of SQL server architecture?
Answers were Sorted based on User's Feedback
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 |
Answer / bhushan
SQL server Architechture is basically a partition of
Logical and Physical data database.
Is This Answer Correct ? | 17 Yes | 11 No |
What is difference between drop truncate and delete?
What are the dmvs? : sql server database administration
Is it possible to call a stored procedure within a stored procedure?
What command do we use to rename a db?
What are the triggers in sql?
how can a database be repaired? : Sql server administration
What is triggers and stored procedures?
where can you add custom error messages to sql server? : Sql server administration
What is the maximum size of a dimension? : sql server analysis services, ssas
How to enable/disable indexes?
Explain partitioned view?
Why we use the openxml clause?