Answer / hari

Sql server is having Physical database & logical database
On Physical Database contians file groups and Transcation
log
in file group Contains data files-36,767 TB
data file contains of tabel -
tabel containts extents
Extents contains Pages
pages Contains rows
Transcation log is Userdefined filegroup by default it's
primary file group
Logical - database objects like
view,Sp,functions,Triggers,Indexes and roles etc

Answer / bhushan

SQL server Architechture is basically a partition of
Logical and Physical data database.

How to make remote connection in database?

0 Answers  

---

Can a function call a stored procedure in sql server?

0 Answers  

---

What is the disadvantages of index?

3 Answers   TCS,

---

What are the various Operating system files that every SQL server 2005 database has and what is the purpose.

0 Answers   Microsoft,

---

Why we need a group by clause?

4 Answers  

---

---

What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?

0 Answers   Accenture,

---

What are the five characteristics of good data?

0 Answers  

---

What are the events recorded in a transaction log?

0 Answers  

---

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

0 Answers  

---

What is sql server transaction log file?

0 Answers  

---

What is implicit mode in sql server?

0 Answers  

---

What is molap and its advantage? : sql server analysis services, ssas

0 Answers  

---