Adding Not Null columns Archives

Adding Not Null Column to Existing Table in SQL Server 2012

August 5, 2012December 23, 2019 - by SQL Geek - Leave a Comment

This blog is the continuation of my last blog link is here; where in I wrote about a new feature in SQL Server 2012 which optimizes addition of a adding not …

SQL Server

SQL Server Add Not Null Column to Existing Table

July 27, 2012December 23, 2019 - by SQL Geek - 2 Comments.

Most of you must have come across the pain of adding a not null column with a default value to an existing big table. It takes minutes to SQL Server Add …