 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / DB Engine / SQL Server / March 2008How long will finish new column add to the biggest table?
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. > Hi All, > [quoted text clipped - 6 lines] > Thanks! > -Chen |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.