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.
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 2
Database Coding Standards and Guidelines Part 2: skip SELECT *, use SET NOCOUNT ON, prefer CTEs over temp tables, avoid cursors, and more query tips.
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.
Searching Every Stored Procedure for a Word
Searching every stored procedure through sys.sql_modules finds text quickly, but comments, case, dynamic SQL, and other databases need care.