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")
Illustrate the multi value or multicolumn problem? Include an example not employed in the text.
What are cliques?
Specify various tools in the Business Objects 5.1?
States the term Volatile temporary tables.
Write down some of the differences between the data query and the knowledge query.
Explain the advantage of Table Partitioning with bcp in Sybase?
Briefly describe the foreign key columns in dimension table and fact table?
What is meant by star schema?
Write a brief note on the market basket analysis?
Illustrates the mobile enterprise application enablement?
18,76,764
1950418 Asked
3,689
Active Tutors
1449212
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!