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 briefly reusable transformations?
Illustrates the term normalization?
Specify the types of join that are available?
What is Datadriven?
Illustrates the difference between a file server and database server?
State the difference between OLTP and OLAP?
Software as a Service (SaaS): It includes the software and applications like Email, Instant Messaging, Office Suites etc. which are provided by the cloud vendor to the customer. Consumers have the
What are the techniques in which an Oracle database can be created?
What is meant by the snow flake schema?
Illustrate the term data mart. What do you mean by it?
18,76,764
1937405 Asked
3,689
Active Tutors
1431310
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!