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 object?
Write down a short note on Website security issues?
What do you mean by the term Open Server in the Sybase?
What is the budget analysis from aircraft solutions?
Demonstrate some of the techniques which can be employed to tune operational performance?
Write down the latest error handling technique in SQL Server 2005?
Explain the term precision in Data Structures? Answer: Precision considers as to the accuracy of the decimal portion of a value. It is the number of digits permitted
Describe the various categories of the range of database application?
Does System development life cycle changes when you use Teradata in place of Oracle?
Describe the difference between the bulk-logged recovery models, full, and SQL Server 2000 simple?
18,76,764
1951753 Asked
3,689
Active Tutors
1415502
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!