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 a primary index?

0 Answers  

---

Explain few examples of stored procedure over triggers?

0 Answers   ADITI,

---

What is Trace flag?

1 Answers   Wipro,

---

What are constraints?

0 Answers  

---

Are connections to sql server encrypted?

0 Answers  

---

What are tasks?

3 Answers   Wipro,

---

What is the difference between WHERE AND IN? OR 1. SELECT * FROM EMPLOYEE WHERE EMPID=123 2. SELECT * FROM EMPLOYEE WHERE EMPID IN (123) WHAT IS THE DIFFERENCE?

15 Answers   Adsys, Cap Gemini,

---

What do you understand by a stored procedure?

0 Answers  

---

what is the difference between openrowset and openquery?

0 Answers  

---

logshipping is Any difference 2000 and 2005?

2 Answers  

---

What is replace and stuff function in sql server?

0 Answers  

---

Explain primary key in sql server?

0 Answers  

---