Answer / Lokendra

A Mixed Extent in SQL Server refers to an allocation unit containing 64 pages (8 KB) of data pages and one GAM page (Global Allocation Map). Mixed extents are used for initial table allocations or when there's no suitable single extent available.

What is difference in performance between insert top (n) into table and using top with insert?

1 Answers  

---

How to Create Login and User through query in Sql server 2005.and also how to delete Login and User through query?

2 Answers  

---

How can I track the changes or identify the latest insert-update-delete from a table?

1 Answers  

---

1 01 101 01010

1 Answers  

---

What are relationships and mention different types of relationships in the dbms

1 Answers  

---

What is the difference between a unique key and primary key?

1 Answers  

---

What is the difference between SSAS 2000 and SSAS 2005?

1 Answers   APX,

---

Can you explain what is sql server english query?

1 Answers  

---

How to Get the last identity value used

4 Answers  

---

What do you understand by sql server agent?

1 Answers  

---

Explain SELF JOIN ?

3 Answers   ADP,

---

What are the database roles? : sql server security

1 Answers  

---