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,912 reads
Dan Ryan
Blogs
What goes around comes around : T-SQL Tuesday #129
I almost died. I’m sure a lot of you already know this but just...
My T-SQL Tuesday #129 Time Capsule
By Steve Jones
This month the T-SQL Tuesday invitation comes from Tamara Clark. I strong-armed Tamara last...
Azure Database Administrator
By Arun Sirpal
Recently I found out that I passed the BETA exam for Azure Database Administrator...
Forums
Send me an email if this job run longer than 30 minutes
Hi I have a job that I need to be notified/emailed if it runs...
Time out expired on the application side
Hi I have an application that is timing out i run the query...
Ask SSC