You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?

0 Answers  

---

Difference between 2NF &3NF ?

0 Answers   Cap Gemini,

---

Explain mixed authentication mode of sql server?

0 Answers  

---

What is the difference between two queries: 1. SELECT * FROM table WHERE 1=1; 2. SELECT * FROM table

17 Answers   HP,

---

What is a view? is View updatable?

17 Answers   IBM, L&T,

---

---

What is the difference between NOROW and LOCKROW?

0 Answers   Accenture, Honeywell, Satyam,

---

Explain trigger and trigger types?

0 Answers  

---

What is a transact-sql statement batch in ms sql server?

0 Answers  

---

what are the Prerequisites for Replication?

1 Answers   IBM,

---

What are different type of Collation Sensitivity?

0 Answers  

---

What are the encryption mechanisms in sql server?

0 Answers  

---

Explain log shipping and mention its advantages.

0 Answers  

---