Use naming conventions for readable SQL Server tables, columns, keys and indexes, then find exceptions and plan safe renames with sp_rename.
Create Constraints Quiz: What Does WITH NOCHECK Leave Behind?
This Create Constraints Quiz adds a CHECK constraint WITH NOCHECK to a table that already holds a bad row. The bad row stays, and the constraint is marked not trusted. A tested script proves it, shows what trust changes for the optimizer and lists four ways to create a constraint.
Data Quality Rules in T-SQL
Data quality rules in T-SQL turn nulls, duplicates, invalid dates, and broken references into visible failures before rows reach reports.
Identity Column Quiz: Why Did My IDs Skip a Number?
This Identity Column Quiz starts with three rows and one rolled-back insert, then asks what ID the next row gets. The answer is 5, not 4. A tested script proves it and shows two more ways numbers go missing.
Surrogate Keys and Natural Keys
Surrogate keys keep warehouse history stable while natural keys preserve source identity; learn lookup, uniqueness, and change handling.
Interview Questions and Answers – Frequently Asked Questions Day 6 of 31
Frequently Asked Questions Day 6: which TCP/IP port SQL Server runs on and how to change it, and the difference between a clustered and a non-clustered index.
SEQUENCE Cache Size, Gaps and Insert Throughput
Compare SEQUENCE cache size, restart gaps, rollback gaps, and insert throughput with CACHE 50, CACHE 1000, and NO CACHE.