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")
Explain what is database connection?
Write down the architectural and functional differentiations between Web Intelligence Reports and business objects?
Define the Linked List in data structure?
Specify different types of transformations available in the Informatica?
Write about the term Data stage architecture?
Write down the latest error handling technique in SQL Server 2005?
State the steps for “this message could not delete” from the particular tables?
What is meant by the fact table?
When must you seem de-normalization?
Define the term Smoothing.
18,76,764
1945327 Asked
3,689
Active Tutors
1428122
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!