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

Answer / hari

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

What is the use of partition by in sql server?

0 Answers  

---

How to rebuild the master database?

0 Answers  

---

Define Check points and End Points?

1 Answers  

---

what is denormalization? : Sql server database administration

0 Answers  

---

How to retrieve error messages using mssql_get_last_message()?

0 Answers  

---

Explain the rules for designing files and file groups in sql server?

0 Answers  

---

What is measure group, measure? : sql server analysis services, ssas

0 Answers  

---

What are Spatial data types in SQL Server 2008

0 Answers   Infosys,

---

What are the different SQL Server Versions you have worked on?

0 Answers  

---

When we can say that is in BCNF?

3 Answers   BitWise,

---

What is serializable?

0 Answers  

---

Explain datetime2 data type in sal server 2008?

0 Answers  

---