@H_404_1@在sql Server 2008 R2上向大型生产表添加列的最佳方法是什么？根据微软的在线书籍：
The changes specified in ALTER TABLE are implemented immediately. If the changes require modifications of the rows in the table,ALTER TABLE updates the rows. ALTER TABLE acquires a schema modify lock on the table to make sure that no other connections reference even the Metadata for the table during the change,except online index operations that require a very short SCH-M lock at the end.
(http://msdn.microsoft.com/en-us/library/ms190273.aspx)
在具有数百万行的大型表上,这可能需要一段时间.停电是唯一的选择吗？处理这种情况的最佳方法是什么？
