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")
Illustrates the ways to tune Reporting Services?
Describe briefly How can we configure mapping in the informatica?
Explain some of the reasons which someone familiar with Microsoft Access will desire to learn VBA?
Write down the snapshot with reference to data warehouse?
What is meant by star schema?
Describe briefly the four JDBC driver types which Sun defines?
Explain some of the data mining tools.
Illustrate the term multimedia data mining in short.
Elucidate what are the basic requirements to join two sources in the source qualifier?
Illustrates the case statement present into stored procedure?
18,76,764
1928520 Asked
3,689
Active Tutors
1459190
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!