 Related Questions Latest Answer : Before knowing about Sybase transaction commit it is first essential to know about Sybase transaction. Sybase transaction is nothing but a number of SQL statements paced and handled between Sybase BEGIN TRANSACTION and Sybase COMMIT or ROLLBACK statement. ... Latest Answer : In addition to syslogshold one can look at master.sysprocess and the physical_io. If this is large (several hundred thousand) you are probably looking at a query doing a table scan. syslogshold tends to only store teh *longest*. ... Read Answers (2) | Asked by : srihari What is the use of 'with check' option in views? Latest Answer : When you create a view using the with check option clause, each insert and update through the view, is validated against the view’s selection criteria. If the rows inserted or updated are out of criteria then it fails and gives error message. For ex, ... How do you check db space and what are the measures available to increase the db space? Latest Answer : sp_helpdb gives information about memory used and available.sp_spaceused - gives space used.. ...
Sponsored Links
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
