An updated SQL Server 2012 script to list every column with specific data types in a database, including user data types, schema and table names.
SQL SERVER – Validating Unique Column Name Across Whole Database
A Unique Column Name check lists existing matches across visible database metadata. I use it as an inspection, not an enforcement guarantee.
SQL SERVER – INFORMATION_SCHEMA.COLUMNS and Value Character Maximum Length -1
Why does INFORMATION_SCHEMA.COLUMNS show -1 as the character maximum length? A reader asked me this simple question, and I explain what the negative value means.
SQL SERVER – Get Schema Name from Object ID using OBJECT_SCHEMA_NAME
Many people join sys.tables and sys.schemas to get a schema name from an object ID. The OBJECT_SCHEMA_NAME function does it in one simple call.
Numbers Table vs GENERATE_SERIES: Building Rows on Demand
Learn numbers table in SQL Server with practical examples, clear checks, common traps, and guidance for your own database.
Resource Database Quiz: Where Do the System Objects Live?
This Resource Database Quiz asks where SQL Server stores the definition of sys.objects and whether BACKUP DATABASE can protect it. The answer is the hidden Resource database. A tested script shows its version, its date and the system objects every database sees.
SQL SERVER – Resource Database ID – 32767
Why does DB_NAME(32767) return NULL? Resource Database ID 32767 belongs to the hidden Resource Database, which you will not find in sys.databases.