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 » TSQL » 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
  • 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