Explain what is log shipping?

0 Answers  

---

How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication

0 Answers  

---

if we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5 5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many times a single term comes..

17 Answers   3i Infotech, Rolta, TCS,

---

What are “lock” hints?

0 Answers  

---

What does the on update no action do?

0 Answers  

---

How can you find out which stored procedures are recompiling?

0 Answers  

---

Delete duplicate rows without using rowid.

0 Answers   Nagarro,

---

What is the optimization being performed in oracle and SQL Server?

0 Answers   Cap Gemini,

---

Explain hostprotectionattribute in sql server 2005?

0 Answers  

---

What is the contrast between sql and pl/sql?

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 are some examples of schemas?

0 Answers  

---