Monthly Archives: September 2012

  1. DBMail on a cluster

    Leave a comment

    September 26, 2012 by Kenneth Fisher

    I’ve always found clusters a pain in the neck.  For my latest pain I just spent the last 2 days …
    Continue reading

  2. Using a TVP instead of Dynamic SQL to pass a list into a SP

    2

    September 25, 2012 by Kenneth Fisher

    A couple of days ago I read Steve Jones’ blog on creating a user defined table type.  This reminded me …
    Continue reading

  3. Funny results from OPTIMIZE FOR AD HOC WORKLOADS

    2

    September 18, 2012 by Kenneth Fisher

    I recently turned on OPTIMIZE FOR AD HOC WORKLOADS for the first time on one of my servers.  When I …
    Continue reading

  4. EXECUTE AS USER = ‘Somebody else’

    Leave a comment

    September 9, 2012 by Kenneth Fisher

    As a database administrator I get lots of security requests. “Please grant me read authority on this table, write on that table, …
    Continue reading

  5. sp_helptext

    6

    September 2, 2012 by Kenneth Fisher

    My manager has been quietly laughing under his breath at me for years. Usually because I much prefer queries and …
    Continue reading

Enter your email address to follow this blog and receive notifications of new posts by email.

Join 1,597 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013