Answer / Pawan Kumar Pandey

The size of a stored procedure in Sybase can increase due to several reasons such as adding or modifying code, compiling with different compilation options, or increased usage of system variables and temporary tables.

How do I turn off marked suspect on my database in sybase?

1 Answers  

---

what is the difference between dbcc checkstorage and other dbcc commands

2 Answers  

---

What is the maximum nesting level of Stored Procedure and Triggers in Sybase?

2 Answers   L&T,

---

How to check sybase database status in linux?

1 Answers  

---

How to view the log files in sybase?

1 Answers  

---

What do you mean by deferred update in sybase?

1 Answers  

---

Why place tempdb and log on low numbered devices?

1 Answers  

---

List the merits of index covering.

1 Answers  

---

what is update statistics in sybase?

1 Answers  

---

Given a table which contains some rows with duplicate keys, how would you remove the duplicates?

1 Answers  

---

What is the drawbacks of normalization?

1 Answers  

---

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

2 Answers  

---