Improve SQL Server Efficiency by Switching to INSTEAD OF Triggers
Tip : Improve SQL Server Efficiency by Switching to INSTEAD OF Triggers
Tip : Improve SQL Server Efficiency by Switching to INSTEAD OF Triggers
I highlight a couple of potential problems discovered in various AdventureWorks-based In-Memory OLTP samples out there, and how to work around them.
The SQL Server team has released CU #11 for SQL Server 2012 RTM. KB article: http://support.microsoft.com/kb/2908007 Build # is 11.0.2424 This build has 15 fixes NOTE: This is THE LAST CU for the RTM branch....
Microsoft has released Cumulative Update #10 for SQL Server 2008 R2 Service Pack 2. KB Article: KB #2908087 15 fixes listed at time of publication Build number is 10.50.4297 Relevant for @@VERSION 10.50.4000 through...
After an initial look at in-memory TVPs at small scale proved promising, I take a closer look at trying to match more values against a much larger table.