Explain the architecture of SQL Server?
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 datetime2 data type in sal server 2008?
How do you Implement SSIS Packages in your Project?
What is the full form of ddl?
What is a unique key constraint?
You want to use a perspective in an mdx query. How do you select the perspective?
What are the advantages of paper records?
How to start sql server browser service?
what's sql server? : Sql server database administration
What is a self join in sql server?
explain different types of cursors? : Sql server database administration
Explain security with sql azure?
What is ms sql server service broker?
Can we perform backup restore operation on tempdb? : sql server database administration
What is sql or structured query language?
What is a subquery in a select query statement in ms sql server?