THE SQL Server Blog Spot on the Web

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


You searched for the word(s):
Showing page 1 of 20 (191 total posts) < 1 second(s)
  • Free E-Books From Microsoft Again

    &nbsp; The Director of Sales Excellence at Microsoft is once again giving away free E-Book downloads.&nbsp; Apparently millions of them in fact on all sorts of topics and products.&nbsp; Well not millions of different E-Books but millions of them were downloaded last year and I suspect this year will be even more. In any case it is a great ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on July 11, 2017
  • Getting Excited about my Practical Performance Monitoring Pre-Con

    &#160; I was working on the demos for my Practical Performance Monitoring Pre-Con at this years IT / Dev Connections in San Francisco and I have to admit I got a little giddy.&#160; The session is geared towards helping a DBA get started in monitoring their SQL Server Instances, especially when they dont have the ability to buy a 3rd party ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on July 2, 2017
  • Finding When Someone Last Ran a DBCC

    &#160; The other day someone on Twitter asked how to find out when or who last ran a DBCC FREEPROCCACHE command on their SQL Server instance. Since this is not an unusual request I figured I would post a few examples of how to find DBCC commands or even many similar commands or events. If you had a regular or Extended Event trace going you could ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on June 28, 2017
  • Seldom Used Keyboard Tricks

    &#160; I was giving an internal talk on SSMS productivity trips and there were a few that I believe are seldom used but can be a real time or keystroke saver that I would like to mention. To the best of my knowledge these will work in any version of SSMS from at least 14.0 onward and likely earlier but I cant verify older versions at this time. ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on June 22, 2017
  • SQL Updates Newsletter–May 2017

    &#160; I missed posting the last few months of these but here is the latest update about the monthly newsletter that a good friend of mine (Fany Carolina Vargas) from Microsoft puts together each month. This shows a whole host of goodies related to SQL Server which include but are not limited to the following: Recent Releases and ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on June 1, 2017
  • New Cumulative Updates for SQL Server 2014

    &#160; Microsoft announced two new CUs for SQL Server 2014 yesterday. Below are the links to the KBs and some quick facts for each CU. Cumulative Update 12 for SQL Server 2014 SP1 SQL Server 2014 Service Pack 1 Cumulative Update #12 Quick Facts 12 Issues Resolved ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on April 18, 2017
  • 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
1 2 3 4 5 Next > ... Last »
Privacy Statement