What is transaction server explicit transaction?

0 Answers  

---

Can you move the resources after pausing the node? : sql server database administration

0 Answers  

---

Which stored procedure will you be running to add a linked server?

1 Answers  

---

how to write the query to select the rows are in the order of either 1,3,5,7... or 2,4,6,8,...

7 Answers   ADP, Satyam, Tech Mahindra,

---

What is the fillfactor concept in indexes?

0 Answers  

---

Can group functions be used in the order by clause in ms sql server?

0 Answers  

---

How to use clusters?

0 Answers   Amdocs,

---

What is a primary index?

0 Answers  

---

Explain the use of containers in ssis and also their types?

0 Answers  

---

Explain table valued parameters in sql server? Why tvp used?

0 Answers  

---

Explain cursor as data base object?

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,

---