What changes in the front end code is needed if mirroring is implemented for the high availability? : sql server database administration

0 Answers  

---

What is a recursive stored procedure in sql server?

0 Answers  

---

New concepts of sql server 2005 use in your project.

0 Answers   TCS,

---

explain what is a schema in sql server 2005? Explain how to create a new schema in a database? : Sql server database administration

0 Answers  

---

1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?

7 Answers   Microsoft,

---

---

If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

0 Answers   Facebook,

---

What are orphan records?

0 Answers  

---

Can a table be moved to different filegroup?

0 Answers  

---

What are partitioned views and distributed partitioned views?

0 Answers  

---

How to enter date and time literals in ms sql server?

0 Answers  

---

Where are SQL server users names and passwords are stored in sql server?

0 Answers   HCL,

---

What is the difference between having clause and where clause in sql server?

0 Answers  

---