{"id":1017,"date":"2014-06-09T19:07:42","date_gmt":"2014-06-09T19:07:42","guid":{"rendered":"http:\/\/reservoirsw.com\/?p=1017"},"modified":"2024-01-06T16:45:26","modified_gmt":"2024-01-06T16:45:26","slug":"june-11-2014-sql-server-2014-in-memory-tables-working-with-millions-of-rows-andy-novick","status":"publish","type":"post","link":"https:\/\/snessug.craftydba.com\/?p=1017","title":{"rendered":"Jun-2014 ~ In-Memory tables: Working with Millions of rows ~ Andy Novick"},"content":{"rendered":"<p><a href=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2013\/01\/AndyNovick.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"alignleft size-thumbnail wp-image-453\" title=\"Andy Novick\" src=\"https:\/\/snessug.craftydba.com\/wp-content\/uploads\/2013\/01\/AndyNovick.jpg\" alt=\"\" width=\"150\" height=\"150\" \/><\/a><br \/>\n<span style=\"color: #800000;\">Presenter:<\/span> Andy Novick<br \/>\n<span style=\"color: #800000;\">Topic:<\/span> SQL Server 2014 In-Memory tables, Working with Millions of rows<\/p>\n<p>Memory optimized tables are one of the cool new features in SQL Server 2014. They\u2019re being marketed as a high transaction throughput solution for OLTP. We\u2019ll take a look at that and at how do they work when you try and work with millions of rows in situations more like data warehousing. This presentation will explore the issues and demonstrate where it can be made to work and where it can\u2019t.<\/p>\n<p><span style=\"color: #800000;\">Biography:<\/span><\/p>\n<p>Andy Novick is a SQL Server Developer in the Boston area with 25 years of database and application development experience. His consulting practice focuses on building applications, including software products that use SQL Server\u2019s capabilities to the maximum. He has developed both OLTP and data warehouse databases with multi-terabytes scale. He has particular expertise in automating data management for such large databases. Other recent projects have included ETL, Security and SQL Injection prevention. Andy is the originator of the popular \u201cSQL Server Load-fest\u201d event conduced in Waltham, MA.<\/p>\n<hr \/>\n","protected":false},"excerpt":{"rendered":"<p>Presenter: Andy Novick Topic: SQL Server 2014 In-Memory tables, Working with Millions of rows Memory optimized tables are one of the cool new features in SQL Server 2014. They\u2019re being marketed as a high transaction throughput solution for OLTP. We\u2019ll take a look at that and at how do they work when you try and [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[184],"tags":[],"class_list":["post-1017","post","type-post","status-publish","format-standard","hentry","category-2014-events"],"_links":{"self":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/1017","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1017"}],"version-history":[{"count":4,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/1017\/revisions"}],"predecessor-version":[{"id":1121,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=\/wp\/v2\/posts\/1017\/revisions\/1121"}],"wp:attachment":[{"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1017"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1017"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/snessug.craftydba.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1017"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}