How to remove duplicate rows from table?

0 Answers  

---

What is blocking and how would you troubleshoot it? : sql server database administration

0 Answers  

---

What is a job?

3 Answers  

---

what are the new features introduced in sql server 2000? : Sql server database administration

0 Answers  

---

difference between function and procedure

3 Answers   Cognizant, HCL, TCS, Theorem,

---

Explain the types of indexes.

0 Answers   Accenture,

---

How to create a new table in a given schema?

0 Answers  

---

how to find number of columns in a table in sql server 2000 and 2005 also

7 Answers   HCL, Virtusa,

---

What does it mean to manipulate data?

0 Answers  

---

What is cursors? And what are the different types of cursor?

0 Answers  

---

When we are using this query to shrink the log file,what exactly it will execute internally? Do we lose any data when we run this script? which data it will truncate in the log file and where it is saved. Please let me know... USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY DBCC SHRINKFILE(<TransactionLogName>, 1) GO

1 Answers   Cognizant,

---

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

0 Answers  

---