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
Tell me what is the order in which the sql query is executed?
You want to check the syntax of a complicated update sql statement without executing it. What command should you use?
What happens if null values are involved in boolean operations?
What are extended events in sql server?
Explain what is dbcc?
What are cascading parameters in ssrs reports?
What is 2nf example?
Explain subquery and state its properties?
How to turn on the mssql api module in php?
Explain the commands in sql server?
How do I save a stored procedure in sql server?
What do I need to start working with sql studio? : sql server management studio
What options are there to delete rows on the publisher and not on the subscriber? : sql server replication
What is a non-clustered index?
What are different types of join?