You may have known that unique index on a string-typed column has limitation on prefix length, which can't guarantee that uniqueness is working properly if… Read More »Gurantee Unique for a Long Text Column
We all know unique constraints reject only duplicated rows from inserting into the database, but in this case, one of my unique indexes also rejects… Read More »Unique Index Reject Distinct Row?
Normally, we build an unique index for protecting the table from inserting duplicate values of combined columns. If the constraint of the unique index is… Read More »Partition Key Makes Unique Index Useless