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

What is replication server in sybase?

448

---

What is replication server? What is its role in sybase?

532

---

What does –i option do in sybase tools?

517

---

What mandatory options are required for bcp command utility?

506

---

What is the drawbacks of normalization?

559

---

---

Differences between clustered and non-clustered in sybase?

416

---

How would you improve throughput in sybase?

472

---

What is the default table size in sybase?

469

---

What are the best monitoring tools for the sybase database?

422

---

Explain mirroring?

488

---

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

462

---

Can I use a named pipe to bcp/dump data out or in in sybase?

587

---

How do I make isql secure in sybase?

464

---

How can set the multipal database ?

2456

---

Explain procedure cache?

517

---