A client table full of NULL values was hurting query plans. Here is what a NOT NULL constraint is, how to add one and why it helped performance.
Primary Key and Null in SQL Server – Interview Question of the Week #071
Can a primary key contain NULL values? No. Here is why primary key and NULL do not mix, and the simple interview question many candidates miss.
SQL SERVER – Identify Table Where Clustered Index is Not a Primary Key – DMV
Let us first see script which will return us tablename with schema where clustered index is not a primary key.
Interview Question of the Week #062 – How to Find Table Without Clustered Index (Heap)?
Not every table has a clustered index. Here is a quick script to find each table without a clustered index, also called a Heap, in your database.
SQL SERVER – View Dependencies on SQL Server: Hard & Soft Way
Most databases I meet as a consultant have no up-to-date documentation. Here is the hard way and the soft way to check SQL SERVER – View Dependencies yourself.
SQL SERVER – Finding Tables with Primary or Foreign Keys
How do you find which tables have a primary key or foreign key? Here are simple queries for finding tables with primary or foreign keys in a database.
Interview Question of the Week #001 – Script to List Foreign Key Relationships and Constraint Name
Interview question: write a script to list Foreign Key Relationships in a database along with each constraint name. Here is my short answer.