Hi All,

Does anyone know, I will be add two new columns with small int data type to
existing table that has 121 million records. How long will finish? We use SQL
Server 2005 EE with SP2 (OS Windows 2003 with SP1).

Thanks!
-Chen

This is roughly impossible to predict. Make sure you add it using ALTER
TABLE and not through any designer in SSMS, and it will probably be fastest
if you make it NULL and don't put any NOT NULL / DEFAULT or other
constraints on it until after the column has been added.


"Chen" <Chen@discussions.microsoft.com> wrote in message
news:41B2BF44-929A-481F-A06F-7DDC5B7992EF@microsoft.com...
> Hi All,
>
> Does anyone know, I will be add two new columns with small int data type
> to
> existing table that has 121 million records. How long will finish? We use
> SQL
> Server 2005 EE with SP2 (OS Windows 2003 with SP1).
>
> Thanks!
> -Chen