Answer / andy

to move physical files to physical path.

Answer / c suresh kumar

using move statement we can store the resultent value

Answer / murthy

Can use MOVE to specify to restore the DB & log to the
specific file path instead of restoring it into its
original location.

how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }

0 Answers   HCL, Wipro,

---

How to execute stored procedure in select statement sql server?

0 Answers  

---

what is the difference in login security modes between v6.5 and 7.0? : Sql server database administration

0 Answers  

---

Accidentally i deleted my table. How can i get that table?

4 Answers  

---

What will be the maximum number of index per table?

0 Answers  

---

Explain important index characteristics?

0 Answers  

---

Can coalesce return null?

0 Answers  

---

What is table valued function and scalar valued functions?

0 Answers  

---

Explain the ways to controlling cursor behavior?

0 Answers  

---

Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting are possible?

0 Answers  

---

There are two tables (T1, T2) with different rows. Find the output of query. Select count(*) from T1,T2.

3 Answers   Amdocs,

---

How do you delete a data source?

0 Answers  

---