Explain what are the events recorded in a transaction log?

0 Answers  

---

What are the properties of primary key?

0 Answers  

---

What is @@Identity in sql?

1 Answers   Cap Gemini,

---

what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration

0 Answers  

---

How do you connect 100 files as a flat file sources in one package of SSIS?

2 Answers  

---

---

Explain what are commit and rollback in sql?

0 Answers  

---

Which sql server table is used to hold the stored procedure script?

0 Answers  

---

What is checkpoint in sql server?

0 Answers  

---

What is the default fill factor value?

0 Answers  

---

What is Files and Filegroups in SQL Server & it's implementation.

1 Answers   Zenith,

---

What are scheduled tasks in sql server?

0 Answers  

---

What are information schema views?

0 Answers  

---