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 transfer data from a cursor to variables with a "fetch" statement?

0 Answers  

---

What is ms sql server index?

0 Answers  

---

Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?

0 Answers  

---

How to avoid cursors?

3 Answers   CarrizalSoft Technologies, HP,

---

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  

---

What do you understand by the data quality services in sql server?

0 Answers  

---

How to write a script for upate the data in prod , i have 50000 row are there

2 Answers   TCS,

---

How to set database to be read_only in ms sql server?

0 Answers  

---

WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,...

2 Answers   TVS,

---

How to write a query with a right outer join in ms sql server?

0 Answers  

---

How can I change procedure name in sql server?

0 Answers  

---

Write SQL queries on Self Join and Inner Join.

0 Answers   Aspiring Minds,

---