Answer Posted / gtp

RESTORE DATABASE NewDatabase
FROM DISK='D:\Backup\NewDatabase.bak'
WITH
MOVE 'NewDatabase' TO 'D:\ActiveDB\NewDatabase.mdf',
MOVE 'NewDatabase_log' TO 'D:\ActiveDB\NewDatabase_log.ldf'

What is the difference between seek predicate and predicate?

1059

---

How to create new table with "create table" statements?

1107

---

What is an indexing strategy?

1010

---

What is logshipping and its purpose?

990

---

What is trigger in salesforce?

983

---

what is blocking? : Sql server database administration

1041

---

Stored Procedure returns data from multiple tables. How to access it in your ASP.Net code?

1058

---

How do I clean up sql server transaction log?

1066

---

What according to you is the difference between mysql and sql server performance?

1087

---

What is an identity column in insert statements?

1022

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

1025

---

How to get a list of columns using the "sys.columns" view in ms sql server?

954

---

Do you think BCNF is better than 2NF & 3NF? Why?

1278

---

What is ms sql server service broker?

991

---

What is global temp table?

994

---