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")
Briefly describe the differentiation between the EXCEPT and INTERSECT operators?
Explain what needs to happen to convert a relation to third normal form?
Elucidate briefly the term metadata reporter?
Specify what data sources are available?
Give brief introduction of the term ‘Service Broker components’?
What do you understand by the term SQL view in DBMS? Briefly describe the utilization of views?
Explain the following term: a) OLAP b) OLTP
Give a brief introduction of the term SAS Business Intelligence?
Illustrates storing of data in stored procedures increase the access time?
Name the methods that are available in storing sequential files?
18,76,764
1949316 Asked
3,689
Active Tutors
1430434
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!