Explain the architecture of SQL Server?
- 2 Answers
- 36275 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
What are the different types of collation sensitivity?
How do I start sql server 2017?
What is the difference between cartesian product and cross join?
How do you troubleshoot errors in a SQL Server Agent Job?
What are the different subsets of sql?
Can you explain what are various ways to enhance the ssrs report?
What are the rendering extensions of ssrs?
In which format does an image save in SQL Server database ?
What is the importance of concurrency control?
What is updatable resultset?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
whats new about truncate in sql server 2008?
Where cross join is used?
Explain transaction server consistency?
What is conditional split?
