Answer Posted / dataarchitect

1. Compression levels are used during either full or log
backups.
2. O is lowest compression level while 9 is highest
compression level
3. Just keep in mind while deciding about compression level
higher compression level will cause max. cpu utilization
and may affect performanc of syste, especially for big db.
4. ASE 15** comes up with new compression levels i.e. 100
and 101 . sybase claims that these are fastes and use less
cpu...

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

876

---

What is the difference between 'dump tran database to physical name' 'dump tran database with truncate_only' and dump tran database with no_log'and in real time when we go to truncate the log?

926

---

What is replication in sybase?

942

---

Can I partition any table in sybase ?

1053

---

What is the difference between replication server and sql remote in sybase?

1000

---

What is the drawbacks of normalization?

1017

---

What happen when we delete the table using trigger?

950

---

Why not max out all my columns sybase?

889

---

What is server replication?

1050

---

You need to remove duplicate rows from a sybase table. How would you do that?

926

---

What is asa ultralite in sybase?

984

---

List similarities and differences between oracle & sybase.

1021

---

What are the catches?

942

---

How do I connect to sybase?

916

---

Explain the advantages of sybase iq.

947

---