How use inner join in sql server?

0 Answers  

---

What is query optimizer in sql server?

0 Answers  

---

What is the difference between a fill factor of 100 and 0?

0 Answers  

---

Explain the dirty pages?

0 Answers  

---

Explain primary key?

0 Answers  

---

What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas

0 Answers  

---

Give me a SQL Query to find out the second largest company?

0 Answers   Ernst Young,

---

What is lock escalation and what is its purpose?

0 Answers  

---

What are different types of statements that are supported by sql?

0 Answers  

---

How do I create a partition table in sql server?

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,

---

How to find the latest updated value in a table without sending any parameters to that query

2 Answers  

---