Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the architecture of SQL Server?
- 2 Answers
- 37192 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
What is normalization? Explain its different types?
Your table has a large character field there are queries that use this field in their search clause what should you do?
what information is maintained within the msdb database? : Sql server administration
How to handle error or exception in sql?
How many types of local tables are there in sql server?
What is the difference between deallocate cursor and close cursor?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
Every night you run a full backup after every 3 three hours you make a differential backup every hour you make an incremental backup in a worst-case scenario, how much work you can lose?
What is openrowset sql server?
Explain important index characteristics?
What is the difference between a "where" clause and a "having" clause?
What is 2nf normalization?
What are the advantages of using cte?
How to drop existing views from a database in ms sql server?
What is identity?
