Answer / Pawan Kumar Maurya

"Hot Add CPU" is a feature in SQL Server 2008 that enables adding additional processing power to a running instance of the database engine without requiring a service restart. This allows for greater scalability and flexibility, as resources can be added or removed dynamically based on workload demands.

How to retrieve range of 10th rows to 20 th rows from total rows from a database table.? (Not from Dataset)

10 Answers   Cognizant, Infosys,

---

What's the difference between a primary key and a unique key?

10 Answers   Wipro,

---

but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

1 Answers  

---

What is candidate key with example?

1 Answers  

---

What is the difference between indexing and hashing?

1 Answers  

---

What is sql server database?

1 Answers  

---

How self join is different from outer join?

1 Answers   Blue Star,

---

How do you size a resultset?

1 Answers  

---

What do you mean by an execution plan? How would you view it?

1 Answers  

---

Can you use order by when defining a view?

1 Answers  

---

How to invoke a trigger on demand?

1 Answers  

---

Why do we partition data?

1 Answers  

---