What are the steps to take to improve performance of a poor performing query? : sql server database administration

0 Answers  

---

Define clusters?

0 Answers  

---

Explain what are sparse columns?

0 Answers  

---

What is temporary table in sql server? Why we use temp table?

0 Answers  

---

i have account table which consists of account name,card no and card no consists 16 digits now i want to retrieve the data if card no starts from 4 then it should print visa and if it starts from 5 then it should print master so plse help me to write simple query with out store procs .

3 Answers  

---

---

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

0 Answers  

---

What number aggregate functions are accessible there in sql?

0 Answers  

---

What is one of the first things you would do to increase performance of a query? For example, a boss tells you that ?a query that ran yesterday took 30 seconds, but today it takes 6 minutes?

2 Answers   Accenture, Merrill Lynch, Wipro,

---

what is cluster and nin-cluster index?

4 Answers  

---

Do you know data definition language, data control language and data manipulation language?

0 Answers  

---

Explain what are the authentication modes in sql server?

0 Answers  

---

Do you think BCNF is better than 2NF & 3NF? Why?

0 Answers   Ernst Young,

---