constraints

Declarative SQL: Using UNIQUE Constraints

  • Article

In SQL, you can express the logic of what you want to accomplish without spelling out the details of how the database should do it. Nowhere is this more powerful than in constraints. In this introduction to Declarative SQL, Joe Celko demonstrates how you can write portable code that performs well and executes some complex logic, merely by creating unique constraints.

2015-12-15

6,149 reads

Set-based Constraint Violation Reporting in SQL Server

  • Article

When you're importing data into an RDBMS in bulk and an exception condition is raised because of a constraint violation, you generally need to fix the problem with the data and try again. The error won't tell you which rows are causing the violation. What if you've thousands of rows to search when it happens? There are solutions, writes William Sisson.

2014-10-16

8,821 reads

SQL Server Unique Constraints for Large Text Columns

  • Article

We are storing large text and URLs that are over 900 bytes in some of our tables and have a requirement to enforce uniqueness in those columns. But SQL Server has a limitation that index size can't be over 900 bytes. How do I enforce uniqueness in these columns and is it possible to achieve this in SQL Server 2005 and above? What are my different options to solve this problem? I heard that we can use CHECKSUM to create a hash, but is it possible to avoid collisions in the hash value as we are storing millions of rows?

2009-11-05

3,006 reads

Blogs

Power Platform Quick Tips – Episode 03: Documenting Power Automate Flow Logic

By

Welcome back to my series on Power Platform quick tips! In this episode you...

State of Database DevOps Survey

By

Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...

HP is the 2019 Laptop Winner

By

This is for me, not necessarily for you, but I decided to go with...

Read the latest Blogs

Forums

I can't Uninstall SQL Server 2016

By sirkinghorse

Hi, I have SQL Server 2016 installed in my machine but I can't uninstall...

Log Shipping - What has changed

By nwood2009

We currently have a situation with a vendor where they will only give us...

Rebuild vs Reorganize

By sergey.gigoyan

Comments posted to this topic are about the item Rebuild vs Reorganize

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers