Answer / Nitesh Kumar Singh

In Sybase, to clear TempDB, you can perform a 'SHUTDOWN' operation followed by a 'STARTUP'. However, be aware that this action will drop all temporary objects in the database. To avoid losing ongoing work, consider using 'ALTER DATABASE TEMPDATA CLEAN ALL' command which cleans the temporary data but does not affect the database itself.

How does partition assignment relate to transactions in sybase?

1 Answers  

---

Explain defncopy and it's usage?

1 Answers  

---

Explain asa, asa ultralite.

1 Answers  

---

Explain the difference between numeric and decimal data types in sybase.

1 Answers  

---

what is update statistics in sybase?

1 Answers  

---

Can I run any transact-sql command on a partitioned table in sybase?

1 Answers  

---

What is the use 'return' keyword in Stored Procedure?

2 Answers  

---

How do I force an index to be used in sybase?

1 Answers  

---

What are Magic Tables?

4 Answers   TCS,

---

How to check sybase database status in linux?

1 Answers  

---

What does –i option do in sybase tools?

1 Answers  

---

Alternative to row at a time processing in sybase?

1 Answers  

---