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 Batches and Session?
Explain the term local container and shared container?
Describe the difference between the bulk-logged recovery models, full, and SQL Server 2000 simple?
Name the methods and types of Collision Resolution Techniques used in each of the type?
Briefly explain the Dashboard in the business intelligence?
Demonstrate some of the techniques which can be employed to tune operational performance?
Give a brief introduction of the term critical column?
Explain three types of SQL database server architecture?
Give a brief introduction of the term data cleaning?
Briefly describe the term Object qualification?
18,76,764
1957442 Asked
3,689
Active Tutors
1422776
Questions Answered
Start Excelling in your courses, Ask an Expert and get answers for your homework and assignments!!