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,910 reads
Dan Ryan
Blogs
New Pluralsight Course – Configuring and Managing Kubernetes Networking, Services, and Ingress
My new course “Configuring and Managing Kubernetes Networking, Services, and Ingress” is now available on Pluralsight here!...
Step By Step Installation of SQL Server 2019 with all features
By Rohit Garg
[MSSQLFUN & Decode ITeS becomes a family of 1500 individuals across the globe. Please...
Step By Step Installation of SQL Server 2019 with all features
By Rohit Garg
[MSSQLFUN & Decote ITeS becomes a family of 1500 individuals across the globe. Please...
Forums
Career Advice: Data Warehouse Architect/Modeler
Maybe some of you would share your thoughts about my situation. I´m working in...
Avamar Backup--Is it good?
Dear Experts, is it good to use Avamar backup for SQL Server, currently we...
Read-only
I read MSFT documentation few times but couldn't find a clear answer. I...
Ask SSC