what is the difference between delete table and truncate table commands? : Sql server database administration

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  

---

How to execute stored procedure and set temp table in sql server?

0 Answers  

---

What are the differences between substr and charindex in sql server.

0 Answers  

---

How can you ensure that the database and sql server based application perform well?

0 Answers  

---

---

Can you explain about buffer cash and log cache in sql server?

0 Answers  

---

What is a natural primary key?

0 Answers  

---

what's the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

---

How to use user defined functions in expressions?

0 Answers  

---

Do you know what are acid properties?

0 Answers  

---

When would you prefer to have a minimum number of indexes?

0 Answers  

---

Explain the difference between primary keys and foreign keys?

0 Answers  

---