Answer / Amit Kumar Prasad

To minimize downtime when moving a database on a SQL Server that serves multiple sites, consider the following steps:
n 1. Backup and Verify: Take a full backup of the source database and verify its integrity.
n 2. Prepare the Destination Server: Install SQL Server on the destination server and configure it with similar settings as the source server.
n 3. Create a New Database: On the destination server, create an empty database with the same name as the source database.
n 4. Detach Source Database: Detach the source database to disconnect it from SQL Server and release its resources.
n 5. Attach Destination Database: On the destination server, attach the backed-up source database to the newly created empty database.
n 6. Update Connections: Update all applications connecting to the source database to connect to the new destination database instead.
n 7. Monitor and Validate: Monitor the new database for any errors or inconsistencies, and validate data if necessary.

How to delete duplicate rows from table except one?

1 Answers  

---

Explain indexed views and partitioned view with their syntax.

1 Answers  

---

9. Write a query to list a new column with the difference in temp of the cities Delhi and Mumbai, Mumbai and Jammu and soon. Consider the following table : City_id City Temp. 1 delhi 40 2 Mumbai 35 3 Jammu 32 4 Pune 18

2 Answers  

---

Where are stored procedures in sql server?

1 Answers  

---

How to change a login name in ms sql server?

1 Answers  

---

What is mapping schema?

1 Answers  

---

Explain the properties of sub-query in sql server?

1 Answers  

---

What is mean by "fill factor" ? and what is mean by "Index "in sql?

1 Answers   iGate, Logica CMG,

---

What is @@rowcount in sql?

1 Answers  

---

What is a document index?

1 Answers  

---

When I delete any data from a table, does the sql server reduce the size of that table?

1 Answers  

---

What is a transaction and why is it important?

1 Answers  

---