What is Locking in Sybase? What are its types?
Latest Answer: Sybase does support locking at row level in version 12.5 onwards.Sybase use locking in below modes- Shared- Exclusive- UpdateFor APL(all page locking), sybase locks data as well index pageFor DOL(data only locks) either row level or data page level, sybase ...
Latest Answer: Rowid function is not supported in ASE, it's only supported in Sybase IQ ...
Explain What is Update Statistics?
Latest Answer: ASE uses two system tables for maintaining stats on tables for obtimized query and data retrival.systabstats is used on table level and is maintained dynamically while sysstatistics maintains information on columns and is not maintained.Update statistcis ...
Latest Answer: Procedure cache is the memory area where compiled query tree run e.g, procedure, batch query. Data Cache is the memory area where data that is required for the current querys running is bought from Disk on to memory for building result ...
Latest Answer: When you install Adaptive Server, it has single default data cache, with a 2K memory pool, one cache partition and a single spinlock. To improve performance you can add data caches and bind databases or database objects to them.use "sp_bindcache" ...
Latest Answer: @@errorlog will display the path of log file ...
Latest Answer: Dump tran with truncate_only if it is not cleared the go for select lct_admin("abort", {process_id [, database_id]}) ...
How to find out the maximum sales of an item for each sales man.The table consists sales_man, item, sales columns, each sales man will have the different sales values for different items.here I have to find out for every sales man, which item he sold maximum
Latest Answer: Autosys is a job scheduling software like Control - M and cron, with the help
of autosys we can define the runtime,day,date,week and which script or program
needs to be run.
The main advantage of using autosys w.r.t crontab is that it is has a Java ...
Latest Answer: Although there are numerous differences, probably the most relevant was the introduction of data-only (pages, row level) locking for tables in 12.x. That was the biggest one that shook up the Sybase community.UDB offers some nice tools not available in ...
View page << Previous 1 [2] 3 4 5 6 7 Next >>
Go Top
