What is a spatial database? It is about lines, points, polygons and their features, and SQL Server was not one. My simple answer plus research documents.
SQL SERVER – UDF – Function to Display Current Week Date and Day – Weekly Calendar
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 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.
Coding Standards: A Short Guide and a Practical Naming Check
Useful SQL coding standards give teams a short rule set with clear exceptions. Run a read-only naming report, check literal underscores in procedure prefixes and review the results before changing objects.