Create and insert into temp table in sql server?

0 Answers  

---

Retrieve the unique rows from table without using UNIQUE and DISTINCT keywords.

0 Answers   Global Logic,

---

Magic Tables ?

2 Answers   Thomson Reuters,

---

How to truncate the log in sql server 2012? : sql server database administration

0 Answers  

---

What is the optimal disk configuration for a database server and what raid configurations would you use if budget is not a constraint?

0 Answers  

---

What is the purpose of a table?

0 Answers  

---

Explain what are commit and rollback in sql?

0 Answers  

---

What is the recovery model? List the types of recovery model available in sql server?

0 Answers  

---

What is the difference between stored procedure and user defined functions?

0 Answers  

---

explain different types of jions with examples briefly?

1 Answers   Zensar,

---

What is the difference between a stored procedure and a user defined function?

0 Answers  

---

my problem is tempdb tempdb(dbname) 77752.95 MB(db size) 25345.03 MB (unallocated size) suppose i increased temp db size 10 gb . after increase the temp db showing 87 gb (dbsize) 25346.03MB(unallocated size)--unallocated size is showing same .please clarify.

1 Answers  

---