How to drop an existing schema in ms sql server?

0 Answers  

---

How sql server executes a statement with nested subqueries?

0 Answers  

---

List out a number of the wants to setup a SQL Server failover cluster?

0 Answers  

---

What is set nocount on?

0 Answers  

---

What are the steps you can take to avoid “deadlocks”?

0 Answers  

---

---

Explain what is the purpose of sql profiler in sql server?

0 Answers  

---

What is normalization and what are the different forms of normalizations?

2 Answers  

---

how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?

0 Answers   Facebook,

---

What is dimension table? : sql server analysis services, ssas

0 Answers  

---

How to disconnect from a sql server using mssql_close()?

0 Answers  

---

What is log shipping?

0 Answers  

---

How to check what was the last restore transaction LSN on Log-Shipping and Mirroring when we doesn't have a Monitor server and Witness server?

2 Answers   IBM,

---