Answer Posted / anto

select getdate()

What is normalization? Explain different forms of normalization?

1074

---

What are the differences between substr and charindex in sql server.

1016

---

Explain the different index configurations a table can have?

887

---

What is the difference between system objects and user objects?

1103

---

What is row_number () and partition by in sql server?

1007

---

What is merge?

934

---

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

971

---

Explain use of expression builder.

953

---

Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?

1069

---

Determine when to use stored procedure to complete sql server tasks?

988

---

Write a SQL command to insert and update only a particular field?

1039

---

What do you understand by replication in sql server? Mention the different types of replication in sql server.

895

---

How do I partition a table in sql server?

988

---

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

987

---

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

932

---