Explain the architecture of SQL Server?
- 2 Answers
- 36525 Views
- ABC, HP, Oracle, I also Faced
- E-Mail Answers
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
How can you check the level of fragmentation on a table?
What is Federation Root Database?
Can you name some of the dml commands in sql?
What is the difference between Clustered and Non-Clustered Index?
How to create sub reports?
What is PROJECTION Operation?
Define union, union all, minus, intersect?
How to find index size for each index on table?
what is denormalization and when would you go for it? : Sql server database administration
How to find tables without indexes?
What are the requirements to use odbc connections in php scripts?
What is compression - row-level and page-level compression?
Describe and explain about SQL native client?
Where is localdb stored?
How do you identify a foreign key?
