18,162 reputation
453102
bio website sqlperformance.com/author/…
location New Zealand
age 45
visits member for 3 years, 4 months
seen 4 hours ago

10h
comment SQL Server - constraint to prevent overlapping dates
Your question seems to be asking how to prevent overlaps. The existing answer shows how to do this using DRI. It also links to an article that describes variations around allowing gaps or not. Seems the same to me, perhaps you need to clarify your question if indeed it is a different problem statement?
10h
reviewed Leave Closed SQL Server - constraint to prevent overlapping dates
10h
comment What is the correct way to ensure unique entries in a temporal database design?
@AndriyM See the comments on Alex's article, re: using MERGE.
11h
reviewed Leave Open Setting up a new database
11h
revised SQL Server mirrored database is stuck in recovery mode
Formatting
11h
reviewed No Action Needed SQL Server mirrored database is stuck in recovery mode
11h
reviewed Close What is role of adaptive server in sql server?
17h
reviewed Close Designing a database for a site that stores content from multiple services?
17h
reviewed Close Recovery from lost SQL Server data file
17h
reviewed Looks OK MySQL Code Works in PHPMyAdmin but not in PHP Page
1d
comment Allow non-sys admin, non-owner of a job to execute it
+1 Excellent answer that will help future visitors to the site as well.
1d
reviewed Reviewed Repair Corrupt Access Database File
1d
reviewed No Action Needed mysqldump drop create use case sensitivity
1d
reviewed No Action Needed Using PGBouncer with HAProxy results in connection errors only after load testing
1d
reviewed No Action Needed Auto-increment ids with multiple inserts in mysql/mariadb
1d
reviewed No Action Needed Allow non-sys admin, non-owner of a job to execute it
1d
reviewed Reviewed How do I include nulls during comparisons in SQL Server?
1d
reviewed No Action Needed Setting up a new database
1d
reviewed Approve suggested edit on system.data.oracleclient requires oracle client software version 8.1.7 or greater
1d
comment Adding warning with sp_add_alert doesn't work with “Greater Than” and SQL Server 2014
Did you report the bug at connect.microsofft.com?