A script and UDF that show each current week date with its day, from Sunday to Saturday, using DATEPART and DATEADD. Handy for a weekly calendar report.
SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL
Insert multiple records with one INSERT statement by combining SELECT and UNION ALL, instead of a separate INSERT for every row. SQL Server 2008 has a newer way.
How to Read a T-SQL Syntax Diagram
Read a T-SQL syntax diagram without guessing: brackets mean optional, braces mean required choices, pipes separate options, and dots repeat items.
How to Read a SQL Server Build Number
Learn how a SQL Server build number identifies the engine release, maps to a cumulative update, and explains differences between two instances.
SQL SERVER – Fix : Error : Error 15401: Windows NT user or group ‘username’ not found. Check the name again.
Error 15401: Windows NT user or group not found. Books Online already covers every cause well, so this post bookmarks the Microsoft guide to troubleshoot it.
geometry SRID Mismatch: NULL Is Not a Zero Distance
geometry SRID mismatch is different from coincident points. Keep both identifiers beside the distance and preserve the distinction between NULL and zero.
SQL SERVER – Database Coding Standards and Guidelines Part 1
Database Coding Standards and Guidelines Part 1: naming rules for tables, stored procedures, triggers, indexes, primary keys and foreign keys.