| |||||
|
How to Save space when inserting rows monotonica More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...) How to Save space when inserting rows monotonically ?
If the columns that comprise the clustered index are monotonically increasing (that is, new row key values are greater than those previously inserted) the following System 11 dbcc tune will not split the page when it's half way full. Rather it'll let the page fill and then allocate another page:
(Continued on next question...)
Other Job Interview Questions
|
||||