What are triggers? How do you invoke a trigger on demand?

0 Answers   Hexaware,

---

Explain the difference between clustered and non-clustered index?

0 Answers  

---

Do you know what are the reporting services components?

0 Answers  

---

How to attach adventureworkslt physical files to the server?

0 Answers  

---

How to check what was the last restore transaction LSN in Log shipping or Mirroring? when we don't have a Monitor or witness server.

0 Answers   IBM,

---

Why are sql functions used?

0 Answers  

---

What is the syntax to execute the sys.dm_db_missing_index_details?

0 Answers  

---

What type of Index will get created after executing the above statement?

0 Answers  

---

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---

write query for fourth maximum salary from employee table

14 Answers   Mind Tree, SP Software,

---

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,

---

Difference between server.transfer and server.execute method?

2 Answers  

---