The inside scoop on SQL / debugging you won't find anywhere else!
SQL High Availability
SQL Server 2014
SQL Wait Types
Browse by Tags
Spread the word!
Tagged Content List
Potential data latency with AlwaysOn Availability Groups and Memory Optimized Tables
Today I was testing a scenario with a readable secondary in an Availability Group (AG). The database in the AG contained a memory-optimized table and I was testing read-only query support on the secondary. The mystery While changes for on-disk tables are replicated near-instantaneously (of course in...
24 Sep 2014
Error message “Invalid column name 'uses_native_compilation'” when scripting objects in SQL 2014 CTP1
Due to the In-Memory OLTP enhancements in SQL 2014, there is metadata support added in the form of a new column: uses_native_compilation in the sys.all_sql_objects catalog view . When you use SMO to retrieve a database object (typically when you script it using the SSMS Generate Scripts wizard, for example...
5 Jul 2013
SQL 2014 In-Memory OLTP ‘Hekaton’: training videos and white papers
Personally, the feature I am most excited about in SQL Server 2014 is the In-Memory OLTP (codenamed ‘Hekaton’) feature. Since SQL Server CTP1 was released, a lot of my interactions with colleagues and customers have revolved around this new feature and the one question everyone has is, how do I get started...
3 Jul 2013
Error 41342 when creating In-Memory OLTP (‘Hekaton’) filegroup
A Twitter conversation unearthed a specific requirement of using in-memory OLTP features, namely the processor instruction set requirements. The user was trying to create a ‘Hekaton’ database using the sample script from here , and was getting error message 41342: The model of the processor on the system...
29 Jun 2013
Page 1 of 1 (4 items)
© 2014 Microsoft Corporation.
Privacy & Cookies