Pages

▼
Sunday, July 7, 2013

What is Deadlock and how to simulate deadlock in Sybase ASE?

›
In multitasking system and multiple processes running at the same time over number of resources sometimes we end up into a situation where ...
Wednesday, September 14, 2011

How to Insert dummy data in a table to increase the size of the table in Sybase ASE?

›
Sometimes it is required to do performance testing of stored procedures and scripts over tables with large volume of data no matter of the e...
Tuesday, September 13, 2011

How to quit from a Sybase ASE session?

›
When connected to a Sybase ASE server we can use the following sybase function to quit the existing session - syb_quit() The syntax to q...

How to find Index List in a Sybase database?

›
Index List - Yes you heard it right, we want to find the index list to find all the indexes in a database. But how to do that? Someone migh...

How to find the names of columns in an Index on a table in Sybase ASE?

›
Ever wondered how sp_helpindex can get the column names in an index created on a Sybase table when the same information is not available ha...
Saturday, September 10, 2011

DefnCopy Utility! How to get Views, Stored Procedures, Trigger structure in a text file?

›
Views, Stored procedures and triggers - sometimes we require to extract the structure or definition of these database objects in a text file...
Thursday, September 8, 2011

How to force a Table Scan in Sybase?

›
Are indexes always useful and mandatory on a table or Is Table scan on a table always a bad news for us? To understand what is good for us w...