SQL 2016 Service Pack 1 Released

— By Lori Brown   @SQLSupahStah

SQL 2016 SP1 has been released. I might be a little late to this announcement but thought I would at least give the download link and some highlights on things that are fixed in it.

Download it from here: https://www.microsoft.com/en-us/download/details.aspx?id=54276

Some of the highlights are:

  • New CREATE OR ALTER that allows functions, triggers, procedures or views to be created without having to test for existence first.

blog_20161222_1

  • New error log message that indicates if tempdb data files are not all the same size

blog_20161222_2

  • New lightweight query profiling via trace flag 7412

https://msdn.microsoft.com/en-us/library/mt791503.aspx

  • Enterprise features now available in Standard Edition.

blog_20161222_3

For more information about blog posts, concepts and definitions, further explanations, or questions you may have…please contact us at SQLRx@sqlrx.com. We will be happy to help! Leave a comment and feel free to track back to us. Visit us at www.sqlrx.com!

Both comments and trackbacks are currently closed.
%d bloggers like this: