Can I create a referential integrity constraint in SQL Server that prevents time overlaps?
34107
What is the correct way to ensure unique entries in a temporal database design?
10500
Sample query/DDL for producing page locks on a clustered index in SQL Server (without hints)
128416
MySQL LIMIT clause equivalent for SQL SERVER
157774
SQL Server Query Plan Hash Collision
138611
Stop SQL Server from ordering results?
32901
Adding a constraint to prevent duplicates in SQL Update Trigger
105896
Finding a Primary Key Constraint on the fly in SQL Server 2005
113703
How to correctly handle dates in queries constraints
152786
How do I conditionally create a stored procedure in SQL Server?
86817
Best approach to remove time part of datetime in SQL Server
144338
Can I add a unique constraint that ignores existing violations?
36538
Counter Cache for a column with conditions?
133877
How to Identify the primary key duplication from a SQL Server 2008 error code?
31820
Data inconsistency prohibition if a table refers to another via two many-to-many relationships
145442
SQL Server: Cannot insert an explicit value into a timestamp column
41952
Add NOT NULL constraint to large table without table scan
102471
SQL: Get records created in time range for specific dates