{"id":193,"date":"2015-04-15T13:00:00","date_gmt":"2015-04-15T20:00:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/dataplatforminsider\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/"},"modified":"2024-01-22T22:48:38","modified_gmt":"2024-01-23T06:48:38","slug":"sql-server-2014-service-pack-1-is-now-available","status":"publish","type":"post","link":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/","title":{"rendered":"SQL Server 2014 Service Pack 1 is now available"},"content":{"rendered":"<p>One year ago, Satya Nadella spoke in San Francisco to <a href=\"http:\/\/blogs.technet.com\/b\/dataplatforminsider\/archive\/2014\/04\/15\/the-data-platform-for-a-new-era.aspx?WT.mc_id=Blog_SQL_Announce_DI\">launch SQL Server 2014<\/a>.\u00a0 Today, we are pleased to announce the release of SQL Server 2014 Service Pack 1\u00a0(SP1). The Service Pack is available for download on the <a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkID=519065&amp;WT.mc_id=Blog_SQL_Announce_DI\">Microsoft Download Center<\/a>. As part of our continued commitment to software excellence for our customers, this upgrade is available to all customers with existing SQL Server 2014 deployments.<\/p>\n<p>SQL Server 2014 SP1 contains fixes to issues that have been reported through our customer feedback platforms and Hotfix solutions provided in SQL Server 2014 CU 1 up to and including CU 5, as well as a rollup of fixes previously shipped in SQL Server 2012 SP2.<\/p>\n<p>A few of the customer-requested updates in Microsoft SQL Server 2014 SP1 are:<\/p>\n<ul>\n<li>Column store performance is improved when batch mode operators spill over to disk. A new XEvent provides insights into column store inserts.<\/li>\n<li>Several issues in buffer pool extension SSD configuration are addressed, including the ability to do instant initialization of the buffer pool extension file.<\/li>\n<li>Certain queries compile faster when using new cardinality estimator, and other cardinality estimation query plans are more efficient when using TF-4199.<\/li>\n<li>The scalability benefits of two trace flags (<a href=\"http:\/\/support.microsoft.com\/kb\/2926217\/EN-US?WT.mc_id=Blog_SQL_Announce_DI\">TF-1236<\/a>, <a href=\"http:\/\/support.microsoft.com\/kb\/2809338?WT.mc_id=Blog_SQL_Announce_DI\">TF-9024<\/a>) are applied automatically.<\/li>\n<li>Backup header information retrieval works better with encrypted backups.<\/li>\n<\/ul>\n<p>Customers like Samsung Electro-Mechanics are already seeing the benefits of upgrading to SQL Server 2014. Samsung improved OLTP performance up to 24 times and DW up to 22 times when they upgraded to SQL Server 2014. \u00a0SBI Liquidity Market sped up their transaction performance by tenfold when they adopted SQL Server 2014 in-memory OLTP.<\/p>\n<p>For information about upgrading to SQL Server 2014, see the tools and resources available at <a href=\"http:\/\/cm-edgetun.pages.dev\/sqlserverupgrade?WT.mc_id=Blog_SQL_Announce_DI\">cm-edgetun.pages.dev\/sqlserverupgrade<\/a>.\u00a0 To trial SQL Server 2014, visit the <a href=\"http:\/\/technet.microsoft.com\/evalcenter\/dn205290.aspx?WT.mc_id=Blog_SQL_Announce_DI\">SQL Server 2014 Evaluation Center<\/a>.<\/p>\n<p>For more highlights of the release, please read the <a href=\"http:\/\/support.microsoft.com\/kb\/3018269?WT.mc_id=Blog_SQL_Announce_DI\">Knowledge Base Article for Microsoft SQL Server\u00a02014 SP1<\/a>.\u00a0 To obtain SQL Server 2014 SP1 with its improved supportability, please visit the links below. SQL Server 2014 with SP1 will be available in additional venues including the Volume Licensing center and via Microsoft Update starting May 1, 2015.<\/p>\n<ul>\n<li><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkID=519065&amp;WT.mc_id=Blog_SQL_Announce_DI\">Microsoft\u00ae SQL Server\u00ae 2014\u00a0SP1<\/a><\/li>\n<li><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkID=524502&amp;WT.mc_id=Blog_SQL_Announce_DI\">Microsoft\u00ae SQL Server\u00ae 2014 SP1 Express<\/a><\/li>\n<li><a href=\"http:\/\/go.microsoft.com\/fwlink\/?LinkID=519066&amp;WT.mc_id=Blog_SQL_Announce_DI\">Microsoft\u00ae SQL Server\u00ae 2014 SP1 Feature Pack<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>One year ago, Satya Nadella spoke in San Francisco to launch SQL Server 2014.\u00a0 Today, we are pleased to announce the release of SQL Server 2014 Service Pack 1\u00a0(SP1). The Service Pack is available for download on the Microsoft Download Center.<\/p>\n","protected":false},"author":1457,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"ep_exclude_from_search":false,"_classifai_error":"","_classifai_text_to_speech_error":"","footnotes":""},"post_tag":[],"product":[],"content-type":[2448],"topic":[],"coauthors":[2487],"class_list":["post-193","post","type-post","status-publish","format-standard","hentry","content-type-updates","review-flag-1593580427-503","review-flag-1-1593580431-15","review-flag-5-1593580452-31","review-flag-new-1593580247-437"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.2 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQL Server 2014 Service Pack 1 is now available - Microsoft SQL Server Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL Server 2014 Service Pack 1 is now available - Microsoft SQL Server Blog\" \/>\n<meta property=\"og:description\" content=\"One year ago, Satya Nadella spoke in San Francisco to launch SQL Server 2014.\u00a0 Today, we are pleased to announce the release of SQL Server 2014 Service Pack 1\u00a0(SP1). The Service Pack is available for download on the Microsoft Download Center.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft SQL Server Blog\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/sqlserver\" \/>\n<meta property=\"article:published_time\" content=\"2015-04-15T20:00:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-01-23T06:48:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png\" \/>\n\t<meta property=\"og:image:width\" content=\"512\" \/>\n\t<meta property=\"og:image:height\" content=\"512\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"SQL Server Team\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:site\" content=\"@SQLServer\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"SQL Server Team\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 min read\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/\"},\"author\":[{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/author\/sql-server-team\/\",\"@type\":\"Person\",\"@name\":\"SQL Server Team\"}],\"headline\":\"SQL Server 2014 Service Pack 1 is now available\",\"datePublished\":\"2015-04-15T20:00:00+00:00\",\"dateModified\":\"2024-01-23T06:48:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/\"},\"wordCount\":355,\"commentCount\":17,\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/\",\"name\":\"SQL Server 2014 Service Pack 1 is now available - Microsoft SQL Server Blog\",\"isPartOf\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#website\"},\"datePublished\":\"2015-04-15T20:00:00+00:00\",\"dateModified\":\"2024-01-23T06:48:38+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQL Server 2014 Service Pack 1 is now available\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#website\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/\",\"name\":\"Microsoft SQL Server Blog\",\"description\":\"Official News from Microsoft\u2019s Information Platform\",\"publisher\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization\",\"name\":\"Microsoft SQL Server Blog\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"contentUrl\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png\",\"width\":259,\"height\":194,\"caption\":\"Microsoft SQL Server Blog\"},\"image\":{\"@id\":\"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"http:\/\/www.facebook.com\/sqlserver\",\"https:\/\/x.com\/SQLServer\",\"https:\/\/www.youtube.com\/user\/MSCloudOS\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQL Server 2014 Service Pack 1 is now available - Microsoft SQL Server Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/","og_locale":"en_US","og_type":"article","og_title":"SQL Server 2014 Service Pack 1 is now available - Microsoft SQL Server Blog","og_description":"One year ago, Satya Nadella spoke in San Francisco to launch SQL Server 2014.\u00a0 Today, we are pleased to announce the release of SQL Server 2014 Service Pack 1\u00a0(SP1). The Service Pack is available for download on the Microsoft Download Center.","og_url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/","og_site_name":"Microsoft SQL Server Blog","article_publisher":"http:\/\/www.facebook.com\/sqlserver","article_published_time":"2015-04-15T20:00:00+00:00","article_modified_time":"2024-01-23T06:48:38+00:00","og_image":[{"width":512,"height":512,"url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2018\/08\/cropped-microsoft_logo_element.png","type":"image\/png"}],"author":"SQL Server Team","twitter_card":"summary_large_image","twitter_creator":"@SQLServer","twitter_site":"@SQLServer","twitter_misc":{"Written by":"SQL Server Team","Est. reading time":"1 min read"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/#article","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/"},"author":[{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/author\/sql-server-team\/","@type":"Person","@name":"SQL Server Team"}],"headline":"SQL Server 2014 Service Pack 1 is now available","datePublished":"2015-04-15T20:00:00+00:00","dateModified":"2024-01-23T06:48:38+00:00","mainEntityOfPage":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/"},"wordCount":355,"commentCount":17,"publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/","name":"SQL Server 2014 Service Pack 1 is now available - Microsoft SQL Server Blog","isPartOf":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#website"},"datePublished":"2015-04-15T20:00:00+00:00","dateModified":"2024-01-23T06:48:38+00:00","breadcrumb":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/2015\/04\/15\/sql-server-2014-service-pack-1-is-now-available\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/"},{"@type":"ListItem","position":2,"name":"SQL Server 2014 Service Pack 1 is now available"}]},{"@type":"WebSite","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#website","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/","name":"Microsoft SQL Server Blog","description":"Official News from Microsoft\u2019s Information Platform","publisher":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#organization","name":"Microsoft SQL Server Blog","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","contentUrl":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-content\/uploads\/2019\/08\/Microsoft-Logo.png","width":259,"height":194,"caption":"Microsoft SQL Server Blog"},"image":{"@id":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/#\/schema\/logo\/image\/"},"sameAs":["http:\/\/www.facebook.com\/sqlserver","https:\/\/x.com\/SQLServer","https:\/\/www.youtube.com\/user\/MSCloudOS"]}]}},"msxcm_display_generated_audio":false,"msxcm_animated_featured_image":null,"_links":{"self":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/193","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/users\/1457"}],"replies":[{"embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/comments?post=193"}],"version-history":[{"count":0,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/posts\/193\/revisions"}],"wp:attachment":[{"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/media?parent=193"}],"wp:term":[{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/post_tag?post=193"},{"taxonomy":"product","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/product?post=193"},{"taxonomy":"content-type","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/content-type?post=193"},{"taxonomy":"topic","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/topic?post=193"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/cm-edgetun.pages.dev\/en-us\/sql-server\/blog\/wp-json\/wp\/v2\/coauthors?post=193"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}