Andy M Mallon - AM²

Databases & Diversity — Checking Integrity

  • Home
  • About Andy
  • Stack Exchange Stuff
    • DBA Stack Exchange
    • Stack Overflow
    • Server Fault
    • Super User
  • GitHub Stuff
    • Profile
    • DBA Database
    • Data Blogger Resource Kit
    • Presentation Content
  • Legal Stuff

Month: October 2023

Enforce a specific constraint to be checked first?

October 6, 2023 Andy 0

Question I have the following SQL Server table : For the two constraints I listed the more important constraint first hoping that if both constraints are violated, the first one would be triggered and displayed to the user. However, it appears the constraints are declared … [Read More]

github logo Github Profile
DBA Database
Data Blogger Resource Kit
Mastodon Logo Mastodon:
[email protected]
DBA.se profile
My Stack Exchange answers (mirror)

Subscribe via Email

Join 979 other subscribers

SSMS Shortcuts

Awards & Programs



Recent Posts

  • Consuming SQL Agent dates & durations
  • Migrating my Stack Overflow answers to blog posts (Sorry for the spam)
  • Not all stats should be auto-updated
  • T-SQL Tuesday: The last ticket I closed
  • Enforce a specific constraint to be checked first?

Archives

Categories

RSS RSS

  • Consuming SQL Agent dates & durations March 7, 2025
  • Migrating my Stack Overflow answers to blog posts (Sorry for the spam) November 11, 2024
  • Not all stats should be auto-updated August 29, 2024
  • T-SQL Tuesday: The last ticket I closed February 13, 2024
  • Enforce a specific constraint to be checked first? October 7, 2023
  • AG secondary is out of sync for hours after index maintenance February 21, 2023
  • Using OPENJSON, can’t get results to GROUP BY December 24, 2022
  • SQL Modulo Function gives the wrong value? November 18, 2022
  • Is SQL Server affected by OpenSSL 3.0 Vulnerabilities: CVE 2022-3786 and CVE 2022-3602 November 8, 2022
  • What’s the use case of disabling an index? September 25, 2022

Copyright © 2025 | Andy Mallon | am2.co