Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the architecture of SQL Server?
- 2 Answers
- 37248 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
Using the customer, and order table in northwind database, please write a query to produce xml?
You want to implement the one-to-many relationship while designing tables. How would you do it?
When is the use of update_statistics command?
What is buffer cash and log cache in sql server?
How can you check the level of fragmentation on a table?
What is a trigger and types of a trigger?
what is dbcc? : Sql server database administration
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
Write down the syntax and an example for create, rename and delete index?
Explain the difference between control flow and data flow?
What do you mean by stored techniques? How would we use it?
How do you test your database? : sql server database administration
What is the importance of a recovery model?
What is the use of toad or sqldbx.?
What are the approximate numeric data types?
