Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the architecture of SQL Server?
- 2 Answers
- 37352 Views
- ABC, HP, Oracle, I also Faced
- E-Mail Answers
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 |
What is bit data type? What's the information that can be stored inside a bit column?
What stored by the model? : sql server database administration
What does executeupdate return?
What does ss stand for sexually?
what is the order of execution of where,having,group by in select stement
6 Answers IBM, Tanla Solutions,
What is a result set object returned by odbc_exec()?
What is cursors?
List out the difference between union and union all in sql server?
How to get a list of columns in a view using the "sp_help" stored procedure?
could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh
How dts is used to extract, transform and consolidate data?
Define union, union all, minus, intersect?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
