Answer Posted / 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

What are the operating modes in which database mirroring runs?

1025

---

how we use window authentication connection with sql server.?

1084

---

Tell me can we use custom code in ssrs?

956

---

What are cursors in ms sql server?

1109

---

Difference between aggregate functions of sql?

1040

---

How to concatenate two binary strings together?

1048

---

Does order by actually change the order of the data in the tables or does it just change the output?

1079

---

explain the storage models of olap? : Sql server database administration

887

---

What the class forname () does?

975

---

What is indexing explain it with an example?

930

---

What are page splits?

958

---

What are the different types of replication you can set up in sql server?

983

---

Explain what is public role in sql server?

1058

---

What is function of master database?

114

---

What is the server name for sql management studio?

948

---