Answer / Rakesh Malhotra

"In SQL Server, a page is the smallest unit of data that can be read or written to the disk. It holds 8 KB of data and metadata for a single table in a database. An extent is a collection of eight adjacent pages within a filegroup. Extents provide physical storage organization for data and indexes in a SQL Server database."

Can you tell me the difference between DELETE & TRUNCATE commands?

15 Answers  

---

what are acid properties? : Sql server database administration

1 Answers  

---

Why do we backup Active Directory ?

1 Answers  

---

if a parameter is not send to a stored procedure what type of identifier is to be used in Stp and if that parameter is not feed to the a query inside the Stp how to validate with out useing IF condition

1 Answers   Aviva,

---

Can a trigger be created on a view?

1 Answers  

---

What is Query Execution Plan? How does it help optimize or tune a database driven application?

2 Answers   Accenture, Polaris,

---

What is data block and how to define data block size?

1 Answers  

---

What does man by sql wildcard characters in sql server?

1 Answers  

---

Why truncate is ddl command?

1 Answers  

---

Is sql server difficult to learn?

1 Answers  

---

Explain the working of sql privileges?

1 Answers  

---

WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX

4 Answers   CarrizalSoft Technologies, L&T,

---