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")
Write down the security level employed in BO?
Explain Triggers and Rules?
Explain the term optimization and performance tuning and its work in practical projects?
Explain about a Cartesian product?
What is meant by the fact table?
Specify the various methods through which we may link the universes?
Explain briefly the term an outer join?
What is Monopoly explain in brief?
Write about the Sequencers?
Cloud Computing – A computing capability that provides an abstraction between the computing resource and its underlying technical architecture (e.g., servers, storage, networks), allowing convenient, on-demand network access to a shared pool of
18,76,764
1945276 Asked
3,689
Active Tutors
1461424
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!