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 difference between differential backups and SQL Server 2000 complete?
Described the impact of signed numbers upon the memory by using Data Structures?
Briefly explain the functional differentiations between COGNOs and BO?
Describe in brief about the Sybase group?
What are the utilities Oracle gives, which are utilize for backup and recovery?
Illustrate the term data mart. What do you mean by it?
What is meant by the Drill Through?
What do you understand by the term RFM analysis?
Explain the operations that can be done with the Data Stage Director?
Illustrates the term Merge Sort?
18,76,764
1939193 Asked
3,689
Active Tutors
1433245
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!