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 16 (158 total posts) < 1 second(s)
  • re: Exists Vs. Count(*) - The battle never ends...

    Claire, I specifically stated &quot;database applications written today&quot; in hopes to avoid that argument. If people are still writing code today because that is how they did it in the past I don't see that as a valid reason to keep doing it. We are only talking about SQL Server and applications written today. Maybe I wasn't clear enough about ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on April 4, 2014
  • re: Successful Backup Messages No More...

    If you issue the DBCC command via TSQL it will only stay active until the next restart of SQL Server. By adding it to the start up parameters it will ensure it is always in effect. Andy
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on March 18, 2014
  • Updated File & Wait Statistics Procedures

    &nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp; For many years I have been using a set of stored procedures to capture and report on both the file and wait statistics inside of SQL Server and I just recently did some minor modifications that I want others to be aware of. Since many of you have received copies of the past revisions ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 13, 2014
  • re: Exists Vs. Count(*) - The battle never ends...

    Vova, it is hard to tell from that link what these tables actually consist of and thus impossible to say. However if the tables are very small all bets are off. &nbsp;And speed (duration) is not always a good indicator of what is happening as many factors can affect duration. Take a look at the amount of work that is being done such as pages read ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on February 13, 2014
  • sp_spaceused Alternative

    &nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp; I dont know why but for some reason I have never liked using sp_spaceused. It probably started a long time ago when the results were often inaccurate due to the meta data being out of date. I am pretty sure that was fixed somewhere along the line but the system stored procedure had some other limitations ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on May 17, 2013
  • re: Successful Backup Messages No More...

    I don't know of any way to rid the log of the restore messages you are concerned with. I see why one would want to supress them just like the backups but so far I haven't found a trace flag for that. If I do find one I will post here.
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on January 22, 2013
  • re: [OT] – Cool Spider

    Derek, These are not dangerous to humans. Nothing to worry about.
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on January 7, 2013
  • re: Presenting at the University of Virginia Tomorrow!

    See you there.
    Posted to Andy Leonard (Weblog) by Andrew Kelly on November 12, 2012
  • Speaking at University of Virginia

    The University of Virginia is having a fall conference that is free and open to the public on Tuesday November 13th. My good friend Andy Leonard and I will be speaking on various SQL Server related topics so if you are in the area and available that day you are most welcome to stop by. You can find more information and register for the ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on November 5, 2012
  • re: Backup File Naming Convention

    Rich, Yes thanks for the reminder. I will amend the topic as I did forget to talk about the _nn for multiple files. I didn't want to get into too much detail about backups per se just the naming. &nbsp;However I never recommend having more than 1 backup or action in a file as a general practice. Sure there may be exceptions but usually not as a ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on October 8, 2012
1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement