Explain way to save space while inserting rows monotonically
Illustrates the way to save space while inserting rows monotonically?
Expert
If the columns which comprise the clustered index are monotonically rising (which is, new row key values are greater than those earlier inserted) the given System 11 dbcc tune will not split the page while it's half way full. Quite it'll let the page fill and after that allocate other page:
dbcc tune(ascinserts, 1, "my_table")
Incidentally, SyBooks is wrong when this states that the above requires to be reset while ASE is rebooted. It is a permanent setting not temporary.To undo this:
dbcc tune (ascinserts, 0, "my _ table")
Describe the some drawbacks of a standard language like SQL?
Briefly explain the sequence clustering algorithm?
Explain what is meant by the term universe stage?
Explain the automated document scheduling and distribution?
Write down the importance for using repository connectivity?
What is cmaxpktsz good for in Sybase?
Illustrates the various extensions for stored procedures?
Write about the Sequencers?
Define the term Cognos 8 BI?
Write down the differentiation between Power Center and Power Mart?
18,76,764
1943221 Asked
3,689
Active Tutors
1457063
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!