Answer Posted / balumahendran

Extreme Power

What are page splits?

587

---

What are the steps you will take to improve the performance of a poor performing query?

601

---

Explain “row_number()” in sql server with an example?

524

---

How do I install sql server?

472

---

Do you know what is a with(nolock)?

605

---

---

Different types of keys in SQL?

635

---

What is use of attributehierarchyenabled? : sql server analysis services, ssas

615

---

What are sql server functions?

520

---

What is meant by indexing?

509

---

If a stored procedure is taking a table data type, how it looks?

5807

---

What are triggers? How many triggers you can have on a table? How to invoke a trigger on demand?

754

---

How to add code to the existing article (using improve article)?

598

---

What are secondary xml indexes?

574

---

What does null mean?

605

---

Explain what is raid and what are different types of raid levels?

539

---