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 |
Can we call future method from queueable?
What is difference between Datepart() and Datename() in SqlServer?
Can you explain the role of each service?
write down the code for "how we delete a table without using of Drop command " ?
7 Answers CarrizalSoft Technologies, Sonata,
What is snapshot replication?
List out different types of normalizations in sql server and explain each of them?
Difference Between varchar and nvarchar datatype?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
After the SQL installation what are the jobs will you configure?
1 Answers G7 CR Technologies, IBM, Satyam,
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
What is difference between clustered index and non clustered index?
When you use @@error and try-catch?