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
What is the downside of using udf?
what is the primary use of the model database? : Sql server administration
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
What is the architecture of ms sql reporting service?
What is tabulation?
Do you know what is lock escalation?
Will the writetext statement activate a trigger?
What is the difference between count and distinct count?
How do I view a trc file?
How to connect to a sql server using odbc_connect()?
What is the stored procedure?
Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?
Explain can SSRS reports Cache results?
What is triggers and its types?
You have modified 100 store procedures and want to replicate these changes from development to prodution, and production can have users using the Server/DB, how would you replicate without causing issues?