Add a NOT NULL column with a named default Column Constraint in one ALTER TABLE statement. I always name constraints instead of letting SQL Server pick one.
Templates and Snippets in SSMS
Templates and snippets in SSMS turn repeated SQL patterns into editable starting points while keeping environment assumptions visible.
SQLAuthority News – Best Articles on SQLAuthority.com
Data Warehousing, Database, DBA, Software Development, SQL Backup and Restore, SQL Coding Standards, SQL Constraint and Keys, SQL Cursor, SQL DateTime, SQL Download, SQL Error Messages, SQL Function, SQL Humor, SQL Index, SQL Joins, SQL Scripts, SQL Server DBCC, SQL Server Security, SQL Stored Procedure, SQL Trigger, SQL Utility
A list of my best articles so far, from killing all processes in a database and shrinking the log file to deleting duplicate rows and UNION vs UNION ALL.
SQL SERVER – Pre-Code Review Tips – Tips For Enforcing Coding Standards
Pre-code review tips for DBAs: why I check stored procedures on our development server every day for coding standards, with a link to my full article.
Why You Should Name Default Constraints
Name default constraints so deployments can find them reliably, and replace system-generated names through a reviewed migration.
Refactoring a Long Stored Procedure Into Readable Steps
Learn refactoring a long stored procedure with output baselines, named temp tables, dead-code removal, and two-way EXCEPT checks before release.
SQL SERVER – Recovery Models and Selection
SQL Server offers three recovery models: full, simple and bulk-logged. Here is when to select each one, based on how much data loss you can accept.