Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the architecture of SQL Server?
- 2 Answers
- 37344 Views
- ABC, HP, Oracle, I also Faced
- E-Mail Answers
Answer Posted / skybeaver
SQL Server was originally developed by Sybase in the mid-
1980s and licensed to Microsoft until 1997. Even today,
most of the core technology in SQL Server is the same as
Sybase Adaptive Server Enterprise. Architecturally, Sybase
and Microsoft are very similar, and both use the Transact-
SQL dialect of SQL that is copyrighted by Sybase. To this
day, Sybase receives a royalty for every copy of SQL Server
sold.
Key architecture points:
1. Multi-threaded, scales to multiple processors
2. Main databases are master, model, tempdb
3. Each database has at least one data segment and one
log segment
4. Transaction log is used for rollback and recovery
| Is This Answer Correct ? | 65 Yes | 15 No |
Post New Answer View All Answers
Explain boyce and codd normal form(bcnf)?
What is function of CUBE ?
How will you add a dimension to cube? : sql server analysis services, ssas
Explain what is lock escalation and what is its purpose?
How many full-text indexes can a table have?
What is the purpose of forms?
What is candidate key with example?
What is a bit datatype?
Mention the different types of triggers?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
what changed between the previous version of sql server and the current version? : Sql server database administration
What is the use of keyword with encryption. Create a store procedure with encryption?
What are basics of policy management?
How many databases Microsoft SQL server provides?
What is the difference between nvl and nvl2?
