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.

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

• New lightweight query profiling via trace flag 7412

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

• 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!