Answer Posted / karthik

tempdb space issues
===================

we will try to clear the tran log by using no_log(or)trunket_only(or)normal backup
>dump tran <databasename> to "/path/<file.txt>"
>go
ofter using this command try to exe some sql quray
if it is not working
>dump tran <databasename> with trunket_only
>go
or
>dump tran <databasename> with no_log
>go
the difference between trunket_only and no_log is check point
trunket_only will wait for checkpoing and no_log is execute with out check point
even tho quary is not executed
>select lct_admin(abort,0,2)
>go

List the merits of index covering.

551

---

Does table partitioning require user-defined segments in sybase?

485

---

How can you change to get the decimal separator as comma instead of the decimal point (.)?

537

---

How do I set a password to be null?

550

---

What happen when we delete the table using trigger?

564

---

---

Tempdb is full. How would you clear it?

557

---

What are triggers? Why do we use them? Diff types of triggers? What are magic tables?

562

---

What are the advantages that you can get from mainframe connect in sybase?

551

---

How to implement if-then-else in a select clause in sybase?

500

---

What causes re-resolution of a stored procedure in sybase?

550

---

Is there a difference in storage type of numeric and decimal data types in sybase? If yes, what?

543

---

Explain about the mainframe connect tools from sybase?

556

---

Alternative to row at a time processing in sybase?

476

---

Compare join and subquery in performance?

624

---

Explanation about replication server software?

567

---