Enforce business rules with indexed views and a two-row table
Here’s a technique that uses a view with a unique index and a dummy table with only two rows to trick SQL Server into enforcing your business rules.
2012-08-20
7,893 reads
Dan Ryan
Blogs
What the ???? T-SQL Tuesday #120
Hey, it’s T-SQL Tuesday again! I almost forgot about it what with Summit and...
First Time Speaking at PASS Summit
By Bert Wagner
This week, I filmed my experience as a first time speaker at PASS Summit...
Azure SQL Best Practices?
By Arun Sirpal
A way to enforce good practice and standards is by Azure Policy. As stated...
Forums
Adding live database to AG
Can this be done without dropping connections to the database? (1) Remove prod database...
backup job is failing
I have configured always on and log backup is failing with the error Command:...
Limiting the Data Frame
Comments posted to this topic are about the item Limiting the Data Frame
Ask SSC