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.

Can I delete event logs?

0 Answers  

---

WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT?

8 Answers  

---

What is bulkcopy in sql?

0 Answers  

---

what is the disadvantage of SQL Loder?

1 Answers   TCS,

---

What is query and its types?

0 Answers  

---

---

Do you know what are the ways available in sql server to execute sql statements?

0 Answers  

---

What is the difference between Clustered and Non-Clustered Index?

0 Answers  

---

What is the usage of the sign function?

0 Answers  

---

How to change location of errorlog in SQL?

2 Answers   ABC, IBM,

---

Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.

4 Answers   Value Labs,

---

What is difference between createstatement and preparedstatement?

0 Answers  

---

What does it mean to have quoted_identifier on? What are the implications of having it off?

2 Answers  

---