THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Tips & Tricks   (RSS)
  • Finding When Someone Last Ran a DBCC

      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

      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 can’t verify older versions at this time. ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on June 22, 2017
  • Finding IP Addresses With CMS

      I was just tasked with putting together a list of all the IP Addresses of the SQL Servers that one of my clients deals with on a daily basis. In this case there was over 30 of them and while I could ping each one individually I found an easier way that you might find useful as well if you are in the same circumstance. I figured there must ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on July 25, 2011
  • The latest edition of the SolidQ Journal is now available

      The SolidQ Journal is published monthly by SolidQ and packed with lots of good information related to SQL Server and related topics. If you haven’t already signed up to get these each month then have a look here.  It’s a free resource that only cost’s you the time to read it .   Andy
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on July 11, 2011
  • The January 2011 Edition of the SolidQ Journal is Out

      The latest edition of the SolidQ Journal is now available online at http://www.solidq.com/sqj/Pages/Home.aspx. Enjoy, Andrew J. Kelly
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on January 17, 2011
  • SQLCMD Execution Order

    I find that many people don’t realize since SQL Server 2005 that you have the ability to execute SQLCMD commands or scripts directly in the Query Editor but it can come in handy at times. Even I don’t use it that as much as I should and I am aware of it:).  One of the things I find it most useful for is during demos at presentations when I ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on June 5, 2009
  • Sometimes you just have to break it up

    I will be the 1st to admit that I am no Itzik Ben-Gan when it comes to writing complex SQL statements and I wonder at times how people come up with some of the Selects that I see.  Sometimes they are so complex or convoluted that I simply have a hard time figuring out the intent or the logic behind them. But as a performance consultant I ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on April 14, 2009
  • When a Function is indeed a Constant

    In my last blog post:  http://sqlblog.com/blogs/andrew_kelly/archive/2008/02/27/when-getdate-is-not-a-constant.aspx I mentioned that I ran across a situation in which GETDATE() used in a SELECT statement occasionally returned more than 1 value for the result set. That sparked quite a debate amongst SQL Server programmers who belonged to ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on March 1, 2008
Privacy Statement