THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » DMVs » administration   (RSS)
  • Finding stored procedures containing %string%

    Having just returned from PASS, I needed to play catch up on a few things in a stored procedure that was being developed before I left.  Being a little frazzled still, I could not for the life of me remember the name of the stored procedure where those things existed.  I constantly find myself manually writing queries like this to find ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on November 9, 2009
  • A Gift of Script for 2008: Who's Active, What Are They Doing, and Who is Blocked?

    As with all of the blog posts I keep meaning to write -- I keep a list and given the infrequency with which I've been posting lately, it's getting quite large -- this script has been on the queue for quite some time. So here I find myself with a spare moment right on the cusp of the new year, and figured what better way to end the year than with a ...
    Posted to Adam Machanic (Weblog) by Adam Machanic on December 31, 2007
Privacy Statement