Enforce case-insensitive unique user names in a case-sensitive database using an indexed computed column with an explicit collation.
NOCHECK CONSTRAINT: Loading Data and Trusting Foreign Keys Again
Use NOCHECK CONSTRAINT carefully, distinguish enabled from trusted foreign keys, validate old rows, and restore optimizer assumptions.
A Unique Constraint That Allows Many NULLs
Allow many NULLs while enforcing unique non-NULL values with a filtered SQL Server index, required SET options, and tested queries.
SQL SERVER – Find Untrusted Foreign Key
Today we are going to see the script in which we can find all the untrusted foreign keys in your database. My client asked this question.
SQL SERVER – CHECK CONSTRAINT to Allow Only Digits in Column
My client during Comprehensive Database Performance Health Check. Today we will learn about CHECK CONSTRAINT to Allow Only Digits in Column.
SQL SERVER – Capturing INSERT Timestamp in Table
The other day while working on a topic of Comprehensive Database Performance Health Check recently asked if I know any trick for capturing insert timestamp.
How to Add Constraint With No Validation? – Interview Question of the Week #299
Question: How to Add Constraint With No Validation?
Answer: I got this question from one of my clients of who is an Oracle user.