Hekaton with a twist: In-memory TVPs – Part 1
I investigate a new possibility in SQL Server 2014: creating and using memory-optimized table-valued parameters.
Monthly Archive: November 2013
November 2013 Cumulative Update for SQL Server 2008 SP3
Microsoft has released SQL Server 2008 Service Pack 3 Cumulative Update #14 Build # 10.00.5848 KB Article: KB #2893410 6 fixes Relevant for builds 10.00.5500 -> 10.00.5847 NOT for SQL Server 2008 R2 (10.50.xxxx)...
SQL Server 2012 Service Pack 1 Cumulative Update #7 is available!
The SQL Server team has released SQL Server 2012 SP1 Cumulative Update #7. KB Article: KB #2894115 Build # is 11.0.3393 Currently there are 47 fixes (plus three undisclosed issues resolved); the most interesting...
Following a single-transaction deadlock across SQL Server versions
I investigate a deadlock issue with alias types and table-valued parameters, and the Connect items that have sprung up about this issue.
October 2013 Cumulative Update for SQL Server 2008 R2
Microsoft has released Cumulative Update #9 for SQL Server 2008 R2 Service Pack 2. KB Article: KB #2887606 17 fixes listed at time of publication Build number is 10.50.4295 Relevant for @@VERSION 10.50.4000 through...
A couple of quick things on PASS feedback
I had a "soft" post on the PASS Summit 2013 speaker feedback.
Script to Set the SQL Server Database Default Schema For All Users
Tip : Script to Set the SQL Server Database Default Schema For All Users