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.

What are the source of constraints?

1015

---

How do I create a trace in sql server?

1126

---

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?

1051

---

Can we shrink data file in sql server?

1135

---

How efficient you are in oracle and SQL server?

1269

---

What are the properties of the transaction?

1079

---

What is in place upgrade in sql server?

1137

---

What is subquery? Explain the properties of a subquery?

1070

---

How do I find the sql server version?

1114

---

What are the different types of subquery?

1239

---

Disadvantages of the indexes?

1230

---

What is standby servers? Explain types of standby servers.

1087

---

What is the difference between for xml raw and for xml auto?

1125

---

Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60

2300

---

what is spatial nonclustered index

1066

---