SQL Updates Newsletter – September 2016


Recent Releases and Announcements

Recent Whitepapers/E-books/Training/Tutorials

 

Monthly Script Tips

 

Issue Alert

  • Critical: Do NOT delete files from the Windows Installer folder. C:\windows\Installer is not a temporary folder and files in it should not be deleted. If you do it on machines on which you have SQL Server installed you may have to rebuild the operating system and reinstall SQL Server.
  • Important: You must precede all Unicode strings with a prefix N when you deal with Unicode string constants in SQL Server
  • Unable to connect to SQL Server on azure VM due to an extra NSG applied to subnet
  • SQL Server 2012 SP2 – CU14 fixes
  • SQL Server 2012 SP3 – CU5 fixes
    • https://support.microsoft.com/en-us/kb/3180915
    • Includes the following fixes among others:
      • SQL Server 2012 crashes with an access violation when you use the TRY…CATCH construct for bulk copy
      • FIX: Assertion failures occur when you query the database-state information in SQL Server 2012
      • CPU usage increases significantly when you execute queries that contain CHANGETABLE functions in SQL Server 2012 Service Pack 3
      • FIX: High CPU usage on SQL queries after you install SQL Server
      • FIX: Queries that run against secondary databases always get recompiled in SQL Server
      • SQL Server crashes because of an access violation error that occurs while it reads data from an event file target
      • SQL Server 2014 or 2012 doesn't start after you configure the tempdb database to use a very small log file
      • "The log backup chain is broken" error when the log backup process fails in SQL Server
    • SQL Server 2016 – CU2 fixes
      • https://support.microsoft.com/en-us/kb/3182270
      • Includes the following fixes among others:
        • FIX: High CPU usage causes performance issues in SQL Server 2016
        • FIX: Deadlock occurs when you acquire a SCH-M lock and alter a partition in SQL Server 2014 or 2016
        • FIX: DML statements are unexpectedly replicated to the subscribers in SQL Server 2014 or 2016
        • FIX: RDL report that's generated programmatically fails to run in SSRS
        • An access violation occurs when you execute two parent packages that run the same child package in parallel in SQL Server 2014 or 2016
        • Query returns incorrect results from nonclustered columnstore index under snapshot isolation level in SQL Server 2016
        • FIX: SQL Server crashes when you run a remote query in a stored procedure by using an invalid user name
        • Operating system error 32 when you restore a database in SQL Server 2014 or 2016
        • Incorrect results are returned when you execute a query that contains a GROUP BY operation in SQL Server 2016
        • A non-optimal query plan choice results in poor performance when values outside the range represented in statistics are searched in SQL Server 2016
        • Updating while compression is in progress can lead to nonclustered columnstore index corruption in SQL Server 2016
        • FIX: An access violation occurs when you use the TDE and BPE features in SQL Server 2014 or 2016
        • A memory leak occurs when you use Azure Storage in SQL Server 2014 or 2016
        • FIX: Access violation occurs when execute a query that contains many COUNT DISTINCT operations in SQL Server 2016
        • An access violation occurs when you execute a query if trace flag 4139 is enabled in SQL Server 2016
        • FIX: Query runs slowly when SQL Server uses hash aggregate in the query plan

 

Recent Blog Posts and Articles

 

Fany Carolina Vargas | SQL Dedicated Premier Field Engineer | Microsoft Services

Comments (1)

  1. Great source of information!! Thanks for the nice write-up!

Skip to main content