Improve SQL Server Efficiency by Switching to INSTEAD OF Triggers
Tip : Improve SQL Server Efficiency by Switching to INSTEAD OF Triggers
Monthly Archive: December 2013
A couple of small issues with Hekaton samples
I highlight a couple of potential problems discovered in various AdventureWorks-based In-Memory OLTP samples out there, and how to work around them.
SQL Server 2012 RTM Cumulative Update #11 is available!
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....
December 2013 Cumulative Update for SQL Server 2008 R2 SP2
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...
Hekaton with a twist: In-memory TVPs – Part 2
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.