Answer / cla

A query execution plan outlines how the SQL Server query optimizer actually ran or possibly run a query

In what version of sql server were synonyms released?

0 Answers  

---

Write the queries for commands like Create Table, Delete table, Drop Table etc.

0 Answers   HPCL, Hughes Systique Corporation,

---

What is a job?

3 Answers  

---

What are the different ways of moving data/databases between servers and databases in SQL Server?

3 Answers   HCL,

---

Tell me what are the essential components of sql server service broker?

0 Answers  

---

what are the new features introduced in sql server 2000? : Sql server database administration

0 Answers  

---

How to create a local temporary stored procedure?

0 Answers  

---

How do I connect to sql server database?

0 Answers  

---

What is inline variable assignment?

0 Answers  

---

what is a transaction and what are acid properties? : Sql server database administration

0 Answers  

---

Which table keeps the locking information?

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,

---