If you are DBA, I am sure you have added columns to tables 1000+ times. But, you know when you are adding a column to a large table, you need extra care. Read the new article on this subject.
This is a nice article..Its very easy to understand ..And this article is using to learn something about it..c#, dot.net, php tutorial, Ms sql serverThanks a lot..!
Posted by Orlando Colamatte at LinkedIn Group : SQL Server 2008Adding a column in the middle of a table can provide some value in terms of performance over adding it as the last column in the table.Adding a column to the middle of a table however requires more steps to implement:1. create a new table with the additonal column in the correct place in the middle of the table all while ensuring the indexes, constraints, keys, partitioning and triggers carry forward to the new table2. copy the data from the existing table into the new table3. drop the existing table4. rename the new table to take the place now vacated by the current tableWhereas adding a column to the end of a table only requires a simple ALTER TABLE statement.