Answer / Dhanvendra Shukla

A partitioned index in SQL Server allows for efficient management of large datasets by dividing an index into smaller, more manageable pieces called partitions. This helps improve query performance and maintenance tasks like rebuilding or reorganizing the indexes. Partitioning can be done based on various factors such as range (partitioning based on a column's value), list (creating partitions for specific values), and round robin (equally distributing data across multiple partitions).

What is page-level compression?

1 Answers  

---

What is the use of SCOPE_IDENTITY() function?

2 Answers  

---

What are sql server procedures?

1 Answers  

---

How to create new databases with "create database" statements?

1 Answers  

---

How do you manipulate data?

1 Answers  

---

1.how to find the dead lock in sql server? 2.How to fine the memory leaks in sql server? 3.suppose transaction log file increasing what action will take ?

1 Answers  

---

Is trigger fired implicitely?

2 Answers  

---

What are the mathematical functions supported by sql server 2005?

1 Answers  

---

Can you create a logon trigger in sql server 2005 express edition?

1 Answers  

---

Is null vs coalesce?

1 Answers  

---

Define left outer join?

1 Answers  

---

How to insert stored procedure result into temporary table?

1 Answers  

---