Explain the architecture of SQL Server?
Answers were Sorted based on User's Feedback
Answer / 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 |
Sql Server is having Physical database and logical database
in physical database-Filegroups,transcation log
Filegroups contains - datafiles
datafiels contains - tables
tables contains - Extents
Extents contains - pages
Pages contains - Rows
Trancastion log is user defined file group by default it is
primary file group,
Logical database objects like
storedprocedre,views,indexes,trigeers
Is This Answer Correct ? | 46 Yes | 26 No |
How do I create an extended event in sql server?
How do you load large data to the SQL server database?
Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???
What are the requirements for sql server 2016?
How to find the date and time of last updated table?
what are questions asked in TCS for database tester (sqlserver)for 2-3 exp?
what is create database syntax? : Sql server database administration
What are differences in between sql server 2012 and sql server 2016?
What is the difference between UNIQUE and DISTINCT keywords in DBMS?
You want to implement the one-to-one relationship while designing tables. How would you do it?
How would you add a section to a table?
How to list all login names on the ms sql server?