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,897 reads
Dan Ryan
Blogs
Extended Events Misperceptions: Profiler is Easier
I know, I know, I’m on #teamexevents so I think that Extended Events can...
I’m Speaking at #SQLSatSpokane
By Angela-Henry
I am super excited to announce that I have been selected to speak at...
Common commands and tasks to make dealing with Windows Core easier.
I don’t know how many of you are working with Windows Core these days...
Forums
Move Data from SQL Server to Azure Blob Storage with Incremental Changes – Part 2
Comments posted to this topic are about the item Move Data from SQL Server...
Knowing What You Don’t Know
Comments posted to this topic are about the item Knowing What You Don’t Know
Automate Import of LIBOR Rates
Does anyone have any recommendations for sites which publish the daily LIBOR rates in...
Ask SSC