Difference between primary key and clustered index?

0 Answers  

---

What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,

---

Can you explain the disadvantages/limitation of the cursor?

0 Answers  

---

What are the security related catalog views? : sql server security

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,

---

---

Do you know exporting and importing utility?

0 Answers  

---

Which tcl commands are available on the sql server?

0 Answers  

---

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

0 Answers  

---

What is forward - only cursors / read only cursor?

0 Answers  

---

what is checksum in sql server.........???

0 Answers   TCS,

---

What is Trigger?

3 Answers   Misys,

---

1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder

3 Answers   CarrizalSoft Technologies, IBM,

---