Tag Archives: system functions

  1. Finding the worst running query in a stored procedure


    September 10, 2015 by Kenneth Fisher

    The other day I was asked to tune a stored procedure. Not exactly an uncommon task, but I worked something …
    Continue reading

  2. Pulling data from the error log


    August 17, 2015 by Kenneth Fisher

    The other day I was asked to pull a list of errors from the SQL Server log into a table …
    Continue reading

  3. Which user function do I use?

    Leave a comment

    June 24, 2015 by Kenneth Fisher

    Earlier this week I was scripting out a table with some legacy columns (InsertDate and InsertBy for example). If you …
    Continue reading

  4. Extending your metadata with Extended Properties


    May 18, 2015 by Kenneth Fisher

    Ever wanted to put a comment on a table? Or maybe even a column? How about an expiration date on …
    Continue reading

  5. Who’s using that database?

    Leave a comment

    March 9, 2015 by Kenneth Fisher

    A common problem when trying to alter a database (take it offline, add a filegroup, whatever) is that someone else …
    Continue reading

  6. Using sp_DBPermissions and sp_SrvPermissions v6.0


    February 25, 2015 by Kenneth Fisher

    It’s been a while since I posted an updated to usp_DBPermissions and usp_SrvPermissions. Sorry. I got lazy with my posting. …
    Continue reading

  7. TSQL Tuesday #62: Invitation to Healthy SQL – Why Page Verify?

    Leave a comment

    January 13, 2015 by Kenneth Fisher

    I don’t think anyone’s ever been happy to get a support call at 11pm on a Saturday night. However this …
    Continue reading

  8. Does a clustered index sort the rows within a page

    Leave a comment

    December 15, 2014 by Kenneth Fisher

    This is just something I was curious about. I ran my tests and got an answer and now I thought …
    Continue reading

  9. Putting sp_ at the beginning of your stored procedure.


    November 24, 2014 by Kenneth Fisher

    Every now and again you see articles and posts about putting sp_ at the beginning of a stored procedure. So …
    Continue reading

  10. Changing configuration settings with sp_configure


    September 22, 2014 by Kenneth Fisher

    I was recently asked where to go in Configuration Manager to change the settings for xp_cmdshell. It was then that …
    Continue reading


Get every new post delivered to your Inbox.

Join 831 other followers