Hi guys,
do you have better approach on handling large table to modify the column existing.
70million rows with 1 clustered and 5 nonclustered index and 4 way partition on the table with datarow lockscheme.
we need modify one column table from char(4) to char(10).
Much appreciated for your thoughts.
TIA.
do you have better approach on handling large table to modify the column existing.
70million rows with 1 clustered and 5 nonclustered index and 4 way partition on the table with datarow lockscheme.
we need modify one column table from char(4) to char(10).
Much appreciated for your thoughts.
TIA.