Explain the architecture of SQL Server?
Answer Posted / hari
Sql Server is having Physical database and logical database
in physical database-Filegroups,transcation log
Filegroups contains - datafiles
datafiels contains - tables
tables contains - Extents
Extents contains - pages
Pages contains - Rows
Trancastion log is user defined file group by default it is
primary file group,
Logical database objects like
storedprocedre,views,indexes,trigeers
Is This Answer Correct ? | 46 Yes | 26 No |
Post New Answer View All Answers
what is a mixed extent? : Sql server administration
is there a column to which a default can't be bound? : Sql server database administration
How would we use distinct statement? What is its use?
Can sql servers link to other servers?
What is service broker?
What is difference between global temporary tables and local temporary tables?
What is the difference between a local and a global temporary table?
How to create user messages with print statements in ms sql server?
what is spatial nonclustered index
What is the difference between push and pull subscription? : sql server replication
How much is a sql server license?
Tell me what are the essential components of sql server service broker?
How do I open a .db file?
What is the difference between insensitive and scroll cursor?
What causes index fragmentation?