What are the results of running this script?

0 Answers  

---

In what version of sql server were synonyms released?

0 Answers  

---

What is difference between joins and subqueries?

0 Answers  

---

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

0 Answers   Ernst Young,

---

What do you mean by a Composite primary key?

0 Answers   Genpact,

---

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

0 Answers  

---

How can a user-defined datatype be created?

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 what is difference between stored procedure and user defined function?

0 Answers  

---

What is the difference between a Local temporary table and a Global temporary table? How is each one used?

2 Answers   HCL,

---

What is the function of inner join?

0 Answers  

---

Can a database be shrunk with users active?

0 Answers  

---