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 the term Chasm trap?
Write brief note on E.F. Codd, and why is he noteworthy in the development of modern database systems?
Give a brief differentiation between Dimensional Modeling and ER Modeling?
Explain the Hash file and the Sequential File?
Describe why stored procedures decreased network traffic.
Explain the term Contexts?
Describe any two reasons which show the necessity of database redesign?
Explain the term DataStage and Informatica?
Describe the difference between a regular sub query and a correlated sub query?
State the difference between the content store and content manager?
18,76,764
1939705 Asked
3,689
Active Tutors
1424376
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!