What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

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,

---

What is resource db in sql server?

0 Answers  

---

what are the different ways to return the rowcount of a table?

0 Answers   Microsoft,

---

What is de-normalization in sql database administration? Give examples?

0 Answers  

---

---

What is temporary stored procedure?

0 Answers  

---

Define DML and DCL statements?

1 Answers   Hexaware, NIIT,

---

explain what is raid and what are different types of raid configurations? : Sql server database administration

0 Answers  

---

If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security

0 Answers  

---

What is the optimization being performed in oracle and SQL Server?

0 Answers   Cap Gemini,

---

If the job running very slow what is the action you do

0 Answers  

---

What are filegroups in sql server?

0 Answers  

---