Indexing foreign keys can speed joins and parent deletes when child-side indexes are missing; learn how to find gaps and test write tradeoffs.
Where Reference Data Should Live
Reference data belongs in governed lookup tables with stable codes, clear owners, and a release process that keeps environments aligned.
SQL SERVER – Disable Clustered Index and Data Insert
A client’s DBA disabled every clustered index before a bulk insert, and the application stopped working. What happens when you disable clustered index?
SQL SERVER – GUID vs INT – Your Opinion
GUID vs INT as a primary key or clustered index: I list one advantage and one disadvantage of each and ask you to add yours in the comments.
SQL SERVER – Create Primary Key with Specific Name when Creating Table
How do you create a primary key with specific name while creating the table itself? One CREATE TABLE statement can define and name the constraint.
Modeling Data Before Writing Tables
Modeling data before tables clarifies entities, relationships, keys, and grain so schema changes do not discover the rules too late.
Building Your Own Sample Data Set
Build a sample data set with realistic keys, skew, NULLs, and repeatable generation when a downloaded sample misses the lesson.