Answer Posted / javed shaikh

What are the different ways of moving data/databases
between servers and databases in SQL Server?
Answer
# 1 There are lots of options available, you have to choose
your option depending upon your requirements. Some of the
options you have are: BACKUP/RESTORE, dettaching and
attaching databases, replication, DTS, BCP, logshipping,
INSERT...SELECT, SELECT...INTO, creating INSERT scripts to
generate data.

How to make conditional sum in ssrs?

132

---

How to write a query with an inner join in ms sql server?

554

---

what is a transaction? : Sql server database administration

474

---

Do you know the capabilities of cursors?

541

---

What are the limitations/drawbacks or ssrs 2008 r2?

86

---

---

How can sql server instances be hidden?

531

---

Mention what are the core components of ssrs?

210

---

Are connections to sql server encrypted?

582

---

What do mean by xml datatype?

625

---

Explain logical operators in sql server?

576

---

What are “lost updates”?

617

---

Explain what are the events recorded in a transaction log?

564

---

How to insert data into an existing table?

575

---

How to write character string constants or literals in ms sql server?

549

---

What is the maximum rows in sql server table?

520

---