THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |

Search

You searched for the word(s):
Showing page 1 of 19 (185 total posts) < 1 second(s)
  • Latest SQL Server 2014 CU Updates

    &#160; Microsoft released a few more Cumulative Updates for SQL Server 2014 as listed below. There are a number of interesting fixes so I highly recommend if you have SQL Server 2014 to take a look at the list of hotfixes included in each update. SQL 2014 SP1 CU11 SQL 2014 SP2 CU4 Happy patching, Andy
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 22, 2017
  • re: Stopping Execution of Future Batches

    Adam, I thought that XACT_ABORT stopped all execution when it encountered an error but I just tried and you are correct in that it will proceed after the next GO so that won't work for multiple batches. I should have tested it first.
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 20, 2017
  • re: Stopping Execution of Future Batches

    Greg, I agree there should be a built in way to do that. However I think you can accomplish that by wrapping the entire script in a BEGIN TRAN and setting XACT_ABORT ON. Yes I know it is not perfect but it will stop execution at that point and rollback any open trans. Andy
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 19, 2017
  • re: Stopping Execution of Future Batches

    Adam, Yes I did some looking afterwards as well and it appears both NOEXEC and PARSEONLY will stop the execution and give the desired results. PARSEONLY checks syntax and object references but does not compile where as NOEXEC does compile. So while it is true PARSEONLY may be a little bit faster for the few times a year when this accidently gets ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 18, 2017
  • Stopping Execution of Future Batches

    &#160; There is a command that as far as I can tell has been in the product since SQL2008 but I was woefully unaware of. Actually I find many others are unaware as well and hence the blog post. The command is SET NOEXEC which has options for ON or OFF.&#160; Normally this is OFF by default and the issue I was trying to solve was this: I have a ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 17, 2017
  • SQL Updates Newsletter – January 2017

    &#160; Here is the latest update about the monthly newsletter that a good friend of mine (Fany Carolina Vargas) from Microsoft puts together each month which shows a whole host of goodies related to SQL Server which include but are not limited to the following: Recent Releases and Announcements Recent White Papers, E-Books, Training and ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 1, 2017
  • Latest SSMS Download (16.5.3)

    &#160; There was a slight issue with the SSMS version that was released a few days back (16.5.2) which has been fixed and replaced with release 16.5.3. If you want the latest SQL Server SSMS 2016 release or if you already loaded the 5.2 version you should get this one. SSMS 2016 Version 16.5.3 Andy
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on January 27, 2017
  • Latest SQL Server Updates

    &#160; There are some new updates for SQL Server 2012 and SQL Server 2016 that were released today. I am not sure what happened to SQL 2014 but I suspect those will be out shortly as well. Here are the links and the associated KBs. SQL Server 2012 Service Pack 2 CU16 KB3205054 SQL Server 2012 Service Pack 3 CU7&#160;&#160; KB3205051 SQL ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on January 18, 2017
  • SQL Updates Newsletter – December 2016

    &#160; Another friendly reminder about the monthly newsletter that a good friend of mine (Fany Carolina Vargas) from Microsoft puts together each month which shows a whole host of goodies related to SQL Server which include but are not limited to the following: Recent Releases and Announcements Recent White Papers, E-Books, Training and ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on January 3, 2017
  • SQL Server 2014 CU3 for SP2 and CU10 for SP1 are Available

    &nbsp; Just an FYI for those of you on SQL Server 2014 SP2 that there is a new CU available for download can can be found here. Also if you are still on SP1 for SQL Server 2014 you can get CU10 as well here. &nbsp;https://www.microsoft.com/en-us/download/details.aspx?id=51186 &nbsp;There are a number of interesting fixes but one in particular ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on December 28, 2016
1 2 3 4 5 Next > ... Last »
Privacy Statement