{"id":4915,"date":"2014-05-08T19:25:08","date_gmt":"2014-05-08T18:25:08","guid":{"rendered":"http:\/\/andreas-wolter.com\/artikel-sql-server-2014-neues-fundament-in-ix-ausgabe-5-2014\/"},"modified":"2017-11-30T19:42:30","modified_gmt":"2017-11-30T18:42:30","slug":"article-sql-server-2014-new-fundament-in-ix-issue-5-2014","status":"publish","type":"post","link":"https:\/\/andreas-wolter.com\/en\/article-sql-server-2014-new-fundament-in-ix-issue-5-2014\/","title":{"rendered":"Article \u201cSQL Server 2014 \u2013 New Fundament\u201d in iX Issue 5\/2014"},"content":{"rendered":"\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_heading-d10ed2c1285130874a6424699cb649f4\">\n#top .av-special-heading.av-av_heading-d10ed2c1285130874a6424699cb649f4{\npadding-bottom:10px;\n}\nbody .av-special-heading.av-av_heading-d10ed2c1285130874a6424699cb649f4 .av-special-heading-tag .heading-char{\nfont-size:25px;\n}\n.av-special-heading.av-av_heading-d10ed2c1285130874a6424699cb649f4 .av-subheading{\nfont-size:15px;\n}\n<\/style>\n<div  class='av-special-heading av-av_heading-d10ed2c1285130874a6424699cb649f4 av-special-heading-h3 blockquote modern-quote  avia-builder-el-0  el_before_av_textblock  avia-builder-el-first '><h3 class='av-special-heading-tag'  itemprop=\"headline\"  >Article <span class='special_amp'>\u201c<\/span>SQL Server 2014 \u2013 New Fundament<span class='special_amp'>\u201d<\/span> in iX Issue 5\/2014<\/h3><div class='av-subheading av-subheading_below'><p>Corrections in In-Memory OLTP and ColumnStore Indexes, and why AlwaysOn is not the same as Always On.<\/p>\n<\/div><div class=\"special-heading-border\"><div class=\"special-heading-inner-border\"><\/div><\/div><\/div>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>In the <a href=\"http:\/\/www.heise.de\/ix\/inhalt\/2014\/5\/56\/\" target=\"_blank\" rel=\"noopener\">May-issue of the iX<\/a>, on page 56, there is an article by me which I wrote together with my colleagues <a href=\"http:\/\/volkerheck.blogspot.de\/\" target=\"_blank\" rel=\"noopener\">Volker Heck<\/a> (Cloud- and BI-Part) and <a href=\"http:\/\/www.dotnet-doktor.de\/dotnetdoktor\/default.aspx\" target=\"_blank\" rel=\"noopener\">Holger Schwichtenberg<\/a> (copy-editing).<\/p>\n<p><!--more--><\/p>\n<\/div><\/section>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-8b5e6eda1e6d3ccda465fe17c5b8889c\">\n.avia-image-container.av-av_image-8b5e6eda1e6d3ccda465fe17c5b8889c img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-8b5e6eda1e6d3ccda465fe17c5b8889c .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-8b5e6eda1e6d3ccda465fe17c5b8889c av-styling- avia-align-center  avia-builder-el-2  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-4902 avia-img-lazy-loading-not-4902 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/11\/1405_iX_Ausgabe_05_2014.jpg\" alt='' title='1405_iX_Ausgabe_05_2014'  height=\"282\" width=\"200\"  itemprop=\"thumbnailUrl\"  \/><\/div><\/div><\/div>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>Unfortunately, in the final version, which I have actually only set eyes on at the newspaper kiosk, there are a few inaccuracies. In order to avoid misunderstandings, I will correct them here shortly, or rather ensure a correct understanding.<\/p>\n<p>Starting with the introduction:<\/p>\n<blockquote>\n<p style=\"padding-left: 30px;\">\u00a01) \u201d\u2026After two years of developing, Microsoft introduces the new version of its database server\u2026\u201d<\/p>\n<\/blockquote>\n<p><strong>Correction: <\/strong>I am not sure as to when the starting shot was made for the SQL Server 2014, but it is quite certain that it was not 2 years before the release date (1 April 2014), as implied by this sentence. A little later, in the article I also say that the In-Memory OLTP Engine XTP was confirmed with its first patent already in 2009. I am not aware of when exactly it was certain that there would be a SQL Server 2014, and that the code would be branched accordingly. If I was to <u>speculate<\/u>, I would say it was more like 3 years before its release.<\/p>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><blockquote>\n<p style=\"padding-left: 30px;\">2) \u201e\u2026The most important innovation is the storing of relational data in the main storage instead of the hard drive.\u201d<\/p>\n<\/blockquote>\n<p><strong>Correction: <\/strong>Those who have already familiarized themselves a little with this new technology will know of course: The data are stored <u>both in RAM and in the hard drive<\/u> \u2013 unless you work with \u201cschema_only\u201d-tables. This will become clear later in the article, but may cause some confusion here.<\/p>\n<blockquote>\n<p style=\"padding-left: 30px;\">3)\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \u201e\u2026Stored Procedures in machine language.\u201c<\/p>\n<\/blockquote>\n<p>\u2026 \u201cNative compiling\u201d \u2026\u201dBefore the first run, the server produces a DLL from the respective procedure for this. These libraries, however, do not last through the restart of database or server, so they have to be generated again afterwards\u2026\u201d<\/p>\n<p>This can be easily misunderstood.<\/p>\n<p><strong>Correction:<\/strong> To be precise, these DLLs are regenerated after each restart of the database or database server (at first usage). \u2013 Thus, one does not have to generate these DLLs or even the procedures new <u>oneself<\/u>.<\/p>\n<blockquote>\n<p style=\"padding-left: 30px;\">4) \u201e(Natively complied procedures) \u2026 Such procedures \u2026 do not yet allow for all T-SQL language elements. For instance, <em>Raiseerror <\/em>and <em>Begin Transaction <\/em>are missing, as well as a few functions and Query Hints.\u201d<\/p>\n<\/blockquote>\n<p>This, too, could be misleading.<\/p>\n<p><strong>Correction:<\/strong> Put more precisely: \u201cFor instance, it is not possible to use particular commands such as <em>Raiseerror<\/em> or <em><u>Begin Transaction, instead of which an \u201catomic\u201d block is required.\u201d<\/u><\/em> The <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/dn452281%28v=sql.120%29.aspx\" target=\"_blank\" rel=\"noopener\">Atomic-Block<\/a><u> already starts a transaction, so an additional \u201cbegin transaction\u201d is superfluous in any case. \u2013 By the way, a few Query Hints are actually supported. <\/u><\/p>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><blockquote>\n<p style=\"padding-left: 30px;\">5) \u201e(new concurrency control, \u201emulti-versioned, timestamped optimistic concurrency control\u201c)\u2026 For this, the server complements all data sets by an automatically updated timestamp created with each change, with the help of which it recognizes conflicts\u2026\u201d<\/p>\n<\/blockquote>\n<p>This can also be easily misinterpreted and may make believe that always the same data set is being updated. However, the background to \u201c<strong>multi-versioned<\/strong>, timestamped optimistic concurrency control\u201d is in fact that there is a new data set per version, which comprehensive tests in realistic test series by Microsoft Research (with more complex transactions combined with longer read access and hotspot scenarios) have shown to be more efficient than \u201cSingle-version locking.\u201d (Source: \u201cHigh-Performance Concurrency Control Mechanisms for Main-Memory Databases,\u201d Microsoft, University of Wisconsin \u2013 Madison)<\/p>\n<p>Single-Version Locking, for example, is applied by Oracle TimesTen and IBM\u2019s solidDB.<\/p>\n<p><strong>Correction:<\/strong> It is thus more precise to say that there is one data set per version, and the \u201cold versions\u201d are marked as such by an end-timestamp.<\/p>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><blockquote>\n<p style=\"padding-left: 30px;\">6) \u201c(Clustered ColumnStore Indexes)\u2026 This enhanced type of the Main-Memory Index Technique was developed for the PDW-version (Parallel Data Warehouse) of the SQL Server 2012 made available in 2013 and is already being applied there\u2026\u201d<\/p>\n<\/blockquote>\n<p>The choice of words suggests that these (Columnstore) indexes, just as with the In-Memory optimized tables &#038; indexes, are located in the main memory only. This is of course not the case.<\/p>\n<p><strong>Correction:<\/strong> More precise would be to say: \u201cMain-Memory-<u>optimized<\/u> Indexes\u201d<\/p>\n<blockquote>\n<p style=\"padding-left: 30px;\">7) And last but not least, I\u2019m afraid in this article, too, a common mistake has slipped in:<\/p>\n<p style=\"padding-left: 30px;\">The solution for high availability and emergency restoration reintroduced in SQL Server 2012 is spelled \u201c<strong>AlwaysOn<\/strong>,\u201d of course; \u2013 neither \u201cAlways On\u201d nor \u201cAlways-On.\u201d \u201cAlways On\u201d (with space) was already applied in SQL Server 2005 in order to certify storage hardware for SQL Server. It includes, for example:<\/p>\n<\/blockquote>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><ul>\n<li>The correct implementation of the APIs, the Write-Ahead Logging (WAL) protocol for both transaction protocols and data and backup files.<\/li>\n<li>The options <em>FILE_FLAG_WRITETHROUGH<\/em> and <em>FlushFileBuffers <\/em>when opening files.<\/li>\n<li>The support of asynchronous I\/O.<\/li>\n<li><i><em>Write ordering. <\/em><\/i><\/li>\n<li>The correction transmission of the sector sizes to the Windows APIs in order to avoid <em>sector size mismatches<\/em> and <em>Torn Writes<\/em>.<\/li>\n<li>The NTFS-abilities such as <em>Sparse Files, File Streams, Encryption, Compression<\/em> and all security properties.<\/li>\n<\/ul>\n<p>\u00a0<\/p>\n<p>You can read more on \u201cAlways On\u201d here, for example:<\/p>\n<p><a href=\"http:\/\/www.dell.com\/downloads\/global\/solutions\/dell_pv_sql_always_on_tech_note_v_1_5.pdf\" target=\"_blank\" rel=\"noopener\">www.dell.com\/downloads\/global\/solutions\/<br \/>\ndell_pv_sql_always_on_tech_note_v_1_5.pdf<\/a><\/p>\n<p>In SQL Server 2008, \u201cAlways On\u201d was used for the entire range of high availability techniques. These include Database Mirroring, Log Shipping, Failover Clustering, Peer-to-Peer Replication, Backup and Restore (!), Database Snapshots, even partitioning, and more. (Read more here: <a href=\"http:\/\/www.google.de\/url?sa=t&#038;rct=j&#038;q=&#038;esrc=s&#038;source=web&#038;cd=2&#038;cad=rja&#038;uact=8&#038;ved=0CDgQFjAB&#038;url=http%3A%2F%2Fdownload.microsoft.com%2Fdownload%2Fc%2Fa%2Ff%2Fcaff7135-8d80-4dad-a104-0da8558d8a0e%2FAvailability%2520DataSheet.pdf\" target=\"_blank\" rel=\"noopener\">High Availability \u2013 Always On Technologies<\/a>) So this does not have anything to do with the new features <strong>AlwaysOn<\/strong>-Availability Groups or <strong>AlwaysOn<\/strong>-Failoverclusterinstances.<\/p>\n<p>What is more, feature names are not simply \u201eGermanized,\u201c just as you do not spell <em>SharePoint<\/em> separately \u2013 and no, I will not even do this for demonstration purposes ;-).<\/p>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>For now, I feel like I have satisfied my <em>sense of accuracy<\/em> \ud83d\ude09<\/p>\n<p>Since the following graph has unfortunately not made it into the article, I would like to share it with my readers here at least:<\/p>\n<\/div><\/section>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_image-f0a7de426b234678322208fdbfe9914f\">\n.avia-image-container.av-av_image-f0a7de426b234678322208fdbfe9914f img.avia_image{\nbox-shadow:none;\n}\n.avia-image-container.av-av_image-f0a7de426b234678322208fdbfe9914f .av-image-caption-overlay-center{\ncolor:#ffffff;\n}\n<\/style>\n<div  class='avia-image-container av-av_image-f0a7de426b234678322208fdbfe9914f av-styling- avia-align-center  avia-builder-el-9  el_after_av_textblock  el_before_av_textblock '   itemprop=\"image\" itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/ImageObject\" ><div class=\"avia-image-container-inner\"><div class=\"avia-image-overlay-wrap\"><img decoding=\"async\" class='wp-image-4904 avia-img-lazy-loading-not-4904 avia_image ' src=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/11\/1405_XTP_Benchmark.png\" alt='' title='1405_XTP_Benchmark'  height=\"323\" width=\"466\"  itemprop=\"thumbnailUrl\" srcset=\"https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/11\/1405_XTP_Benchmark.png 466w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/11\/1405_XTP_Benchmark-300x208.png 300w, https:\/\/andreas-wolter.com\/wp-content\/uploads\/2017\/11\/1405_XTP_Benchmark-450x312.png 450w\" sizes=\"(max-width: 466px) 100vw, 466px\" \/><\/div><\/div><\/div>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>This is the result of a performance comparison of a schematically virtually identical \u201con-disc\u201d-table compared to the different In-Memory OLTP variants. The test was carried out with standard hardware: Intel i7-3529 (2,9Ghz), 2 Cores hyperthreaded, 16GB RAM and SSDs. The result is quite impressive and matches Microsoft\u2019s promise that new hardware is not imperative in order to obtain tangible performance gains through the application of the XTP-Engine.<\/p>\n<p>These are the corresponding links to the article:<\/p>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><ul>\n<li><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/dn133181%28v=sql.120%29.aspx\" target=\"_blank\" rel=\"noopener\">Liste der unterst\u00fctzten SQL-Server-Features bei In-Memory-OLTP<\/a> \/ <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/dn133181%28v=sql.120%29.aspx\" target=\"_blank\" rel=\"noopener\">List of the supported SQL-Server-Features in In-Memory-OLTP<\/a><\/li>\n<li><a href=\"http:\/\/research.microsoft.com\/pubs\/178758\/bw-tree-icde2013-final.pdf\" target=\"_blank\" rel=\"noopener\">The Bw-Tree: A B-tree for New Hardware Platforms<\/a><\/li>\n<li><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/dn452279%28v=sql.120%29.aspx\" target=\"_blank\" rel=\"noopener\">Liste der unterst\u00fctzten SQL-Befehle bei kompilierten Stored Procedures<\/a> \/ <a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/dn452279%28v=sql.120%29.aspx\" target=\"_blank\" rel=\"noopener\">List of supported SQL-commands in compiled Stored Procedures<\/a><\/li>\n<li>Microsoft Case Studies\n<ul>\n<li><a href=\"http:\/\/www.microsoft.com\/casestudies\/Case_Study_Detail.aspx?casestudyid=710000003117\" target=\"_blank\" rel=\"noopener\">http:\/\/www.microsoft.com\/casestudies\/Case_Study_Detail.aspx?casestudyid=710000003117<\/a><\/li>\n<li><a href=\"http:\/\/www.microsoft.com\/casestudies\/Microsoft-SQL-Server-2012\/Ferranti-Computer-Systems\/Utilities-ISV-Scales-to-Meet-Customer-Needs-for-Storage-and-Analysis-of-Big-Data\/710000003000\" target=\"_blank\" rel=\"noopener\">http:\/\/www.microsoft.com\/casestudies\/Microsoft-SQL-Server-2012\/Ferranti-Computer-Systems\/Utilities-ISV-Scales-to-Meet-Customer-Needs-for-Storage-and-Analysis-of-Big-Data\/710000003000<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a href=\"http:\/\/msdn.microsoft.com\/de-de\/library\/gg492153%28v=sql.120%29.aspx\" target=\"_blank\" rel=\"noopener\">Dokumentation zum Column Store Index<\/a> \/ <a href=\"http:\/\/msdn.microsoft.com\/de-de\/library\/gg492153%28v=sql.120%29.aspx\" target=\"_blank\" rel=\"noopener\">Documentation of Column Store Index<\/a><\/li>\n<li><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/dn133176%28v=sql.120%29.aspx\" target=\"_blank\" rel=\"noopener\">Buffer Pool Extension<\/a><\/li>\n<li><a href=\"http:\/\/www.sqlperformance.com\/2013\/12\/t-sql-queries\/a-first-look-at-the-new-sql-server-cardinality-estimator\" target=\"_blank\" rel=\"noopener\">\u00c4nderungen im Cardinality Estimator<\/a> \/ <a href=\"http:\/\/www.sqlperformance.com\/2013\/12\/t-sql-queries\/a-first-look-at-the-new-sql-server-cardinality-estimator\" target=\"_blank\" rel=\"noopener\">Changes in Cardinality Estimator<\/a><\/li>\n<li><a href=\"http:\/\/www.windowsazure.com\/\" target=\"_blank\" rel=\"noopener\">Windows Azure<\/a><\/li>\n<li><a href=\"http:\/\/msdn.microsoft.com\/en-us\/library\/windowsazure\/dn369873.aspx\" target=\"_blank\" rel=\"noopener\">Premium Preview for SQL Database Guidance<\/a><\/li>\n<li><a href=\"http:\/\/www.microsoft.com\/en-us\/powerbi\/\" target=\"_blank\" rel=\"noopener\">PowerBI for Office 365<\/a><\/li>\n<\/ul>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>I hope the points above are helpful for a better understanding not only of the article but also of SQL Server 2014 in general.<\/p>\n<p>You are welcome to leave comments or questions in my blog.<\/p>\n<p>Andreas Wolter<\/p>\n<\/div><\/section>\r\n\r\n<section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><p>P.S.: Unfortunately, there are no spots left (!) in my Master-Class <a href=\"http:\/\/www.sql-server-master-class.com\/#XTC\" target=\"_blank\" rel=\"noopener\"><strong>Workshop In-Memory OLTP &#038; ColumnStore &#8211; New Storage Engines in SQL Server 2014 <\/strong>(XTC)<\/a>. The decision for a remake either in the second half of 2014, or only in the first half of 2015, will probably be made in summer. \u2013 For the second half of 2014, many conferences, including MVP Summit, PASS Summit and PASS Camp, are lined up, so it is already quite cramped. The prospects may thus often be better for an in-house-training on request.<\/p>\n<\/div><\/section>\r\n\r\n<div  class='hr av-av_hr-0ff602b3e980a3377077ff3c1c834df6 hr-default  avia-builder-el-14  el_after_av_textblock  el_before_av_one_full '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_one_full-97c650ae075063b375f558a776c570f8\">\n#top .flex_column.av-av_one_full-97c650ae075063b375f558a776c570f8{\nmargin-top:40px;\nmargin-bottom:40px;\n}\n.flex_column.av-av_one_full-97c650ae075063b375f558a776c570f8{\nborder-radius:0px 0px 0px 0px;\npadding:0px 0px 0px 0px;\n}\n.responsive #top #wrap_all .flex_column.av-av_one_full-97c650ae075063b375f558a776c570f8{\nmargin-top:40px;\nmargin-bottom:40px;\n}\n<\/style>\n<div  class='flex_column av-av_one_full-97c650ae075063b375f558a776c570f8 av_one_full  avia-builder-el-15  el_after_av_hr  el_before_av_social_share  first flex_column_div av-zero-column-padding  '     ><section  class='av_textblock_section av-av_textblock-2de302bf1aa3cf4c9157dbe6f50ac7eb '   itemscope=\"itemscope\" itemtype=\"https:\/\/schema.org\/BlogPosting\" itemprop=\"blogPost\" ><div class='avia_textblock'  itemprop=\"text\" ><div><\/div>\n<div><\/div>\n<\/div><\/section><\/div>\r\n\r\n<div  class='av-social-sharing-box av-av_social_share-8644d330ffb238fff0cfa858c5295467 av-social-sharing-box-default  avia-builder-el-17  el_after_av_one_full  el_before_av_hr  av-social-sharing-box-fullwidth'><div class=\"av-share-box\"><h5 class='av-share-link-description av-no-toc '>Share<\/h5><ul class=\"av-share-box-list noLightbox\"><li class='av-share-link av-social-link-facebook' ><a target=\"_blank\" aria-label=\"Share on Facebook\" href=\"https:\/\/www.facebook.com\/sharer.php?u=https:\/\/andreas-wolter.com\/en\/article-sql-server-2014-new-fundament-in-ix-issue-5-2014\/&#038;t=Article%20%E2%80%9CSQL%20Server%202014%20%E2%80%93%20New%20Fundament%E2%80%9D%20in%20iX%20Issue%205%2F2014\" aria-hidden=\"false\" data-av_icon=\"\ue8f3\" data-av_iconfont=\"entypo-fontello\" title=\"\" data-avia-related-tooltip=\"Share on Facebook\" rel=\"noopener\"><span class='avia_hidden_link_text'>Share on Facebook<\/span><\/a><\/li><li class='av-share-link av-social-link-twitter' ><a target=\"_blank\" aria-label=\"Share on Twitter\" href=\"https:\/\/twitter.com\/share?text=Article%20%E2%80%9CSQL%20Server%202014%20%E2%80%93%20New%20Fundament%E2%80%9D%20in%20iX%20Issue%205%2F2014&#038;url=https:\/\/andreas-wolter.com\/en\/?p=4915\" aria-hidden=\"false\" data-av_icon=\"\ue8f1\" data-av_iconfont=\"entypo-fontello\" title=\"\" data-avia-related-tooltip=\"Share on Twitter\" rel=\"noopener\"><span class='avia_hidden_link_text'>Share on Twitter<\/span><\/a><\/li><li class='av-share-link av-social-link-linkedin' ><a target=\"_blank\" aria-label=\"Share on LinkedIn\" href=\"https:\/\/linkedin.com\/shareArticle?mini=true&#038;title=Article%20%E2%80%9CSQL%20Server%202014%20%E2%80%93%20New%20Fundament%E2%80%9D%20in%20iX%20Issue%205%2F2014&#038;url=https:\/\/andreas-wolter.com\/en\/article-sql-server-2014-new-fundament-in-ix-issue-5-2014\/\" aria-hidden=\"false\" data-av_icon=\"\ue8fc\" data-av_iconfont=\"entypo-fontello\" title=\"\" data-avia-related-tooltip=\"Share on LinkedIn\" rel=\"noopener\"><span class='avia_hidden_link_text'>Share on LinkedIn<\/span><\/a><\/li><\/ul><\/div><\/div>\r\n\r\n\n<style type=\"text\/css\" data-created_by=\"avia_inline_auto\" id=\"style-css-av-av_hr-4474f20d2389e2e5ecf918a02da5132e\">\n#top .hr.hr-invisible.av-av_hr-4474f20d2389e2e5ecf918a02da5132e{\nheight:50px;\n}\n<\/style>\n<div  class='hr av-av_hr-4474f20d2389e2e5ecf918a02da5132e hr-invisible  avia-builder-el-18  el_after_av_social_share  el_before_av_comments_list '><span class='hr-inner '><span class=\"hr-inner-style\"><\/span><\/span><\/div>\r\n\r\n<div  class='av-buildercomment av-av_comments_list-88ce68e426f11248fa394058a3de040f  av-blog-meta-author-disabled av-blog-meta-html-info-disabled'><\/div>","protected":false},"excerpt":{"rendered":"In the May-issue of the iX, on page 56, there is an article by me which I wrote together with my colleagues Volker Heck (Cloud- and BI-Part) and Holger Schwichtenberg (copy-editing).","protected":false},"author":4,"featured_media":4910,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[73,46,36],"tags":[170,311,23,174,88],"class_list":["post-4915","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-columnstore-index","category-in-memory-oltpxtp-htap","category-sql-server-2014","tag-alwayson-en","tag-artikel-en","tag-columnstore-en","tag-sql-server-2014-en","tag-xtp-en"],"_links":{"self":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/4915","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/comments?post=4915"}],"version-history":[{"count":2,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/4915\/revisions"}],"predecessor-version":[{"id":4918,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/posts\/4915\/revisions\/4918"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media\/4910"}],"wp:attachment":[{"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/media?parent=4915"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/categories?post=4915"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/andreas-wolter.com\/en\/wp-json\/wp\/v2\/tags?post=4915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}