you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration

0 Answers  

---

What are the type of Indexes? which one is best, why?

6 Answers  

---

how to find maximum identity number in a table ?

2 Answers   JPMorgan Chase, Thomson Reuters, Wipro,

---

What is the maximum size of a dimension? : sql server analysis services, ssas

0 Answers  

---

What is join query?

0 Answers  

---

---

Tell me about the approaches which you used to counter the DI problems.

0 Answers   EXL,

---

Explain about SQL server 2005?

0 Answers  

---

Explain data warehousing in sql server?

0 Answers  

---

What is a view? is View updatable?

17 Answers   IBM, L&T,

---

Explain what is lock escalation?

0 Answers  

---

What is the cartesian product of the table?

0 Answers  

---

What is the query optimization statistics?

1 Answers  

---