Sql server alter column not null to null

Top sites by search query "sql server alter column not null to null"

  http://blog.sqlauthority.com/2008/12/20/sql-server-change-collation-of-database-column-t-sql-script/
I changed the database collation to the correct one and when I ran the process it created a new database and assigned the default (correct) collation to all the columns. If you have any good idea about this subject, I encourage you to write down good small post about the subject and I publish as blog post with due credit to you along with your contact info

  http://blog.sqlauthority.com/2010/10/18/sql-server-change-column-datatypes/
due to some reason ASP.NET Enterprise Manager changed my entire varchar datatype to text and it causes some section down in my blog but finally Google Maharaaz sent me here and fixed. Fill in your details below or click an icon to log in: Email (required) (Address never made public) Name (required) Website You are commenting using your WordPress.com account

sql server 2008 - Quickly change NULL column to NOT NULL - Database Administrators Stack Exchange

  http://dba.stackexchange.com/questions/48872/quickly-change-null-column-to-not-null
One problem with this is that even if you know the column in fact has no NULLs the constraint is not trusted by the query optimiser which means that the plans can be sub optimal. Adding the constraint with NOCHECK means that no rows will need to be read to verify it, and if you are starting from a position where the column does not contain NULL values (and if you know none will be added between checking and adding the constraint) then, as the constraint prevents NULL values being created from future INSERT or UPDATE operations, this will work