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
Where are stored procedures in sql server?
What have included columns when we talk about sql server indexing?
Do you know what is difference between index seek vs. Index scan?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
How to insert data with null values?
What is normalization? Explain its different types?
What are exact numeric data types in ms sql server?
Explain the working of sql privileges?
Tell me what is the difference between locking and multi-versioning?
What is correlated subquery in sql server?
Explain “not null constraint” in sql server?
Can you name a few encryption mechanisms in sql server?
How do I find the transaction log size in sql server?
What are the advantages dts has over bcp?
How to write a query with a right outer join in ms sql server?