SQL 2016 Service Pack 1 Released

By Lori Brown | SQL Administration

Dec 22

— 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.


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


  • New lightweight query profiling via trace flag 7412


  • Enterprise features now available in Standard Edition.


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!