Category Archives: System Functions and Stored Procedures

  1. Running code on the startup of SQL Server

    1

    February 1, 2016 by Kenneth Fisher

    Every now and again you need to run code when your instance starts up. For example you might want to …
    Continue reading

  2. Finding the worst running query in a stored procedure

    14

    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

  3. Pulling data from the error log

    6

    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

  4. Which user function do I use?

    1

    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

  5. Extending your metadata with Extended Properties

    8

    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

  6. 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

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

    1

    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

  8. Using T-SQL to populate a Central Management Server

    4

    November 17, 2014 by Kenneth Fisher

    We have been using a CMS (Central Management Server) at my office for the last few years. Even beyond the …
    Continue reading

  9. TSQL Tuesday #60: Something New Learned – What permissions does <username> have?

    5

    November 11, 2014 by Kenneth Fisher

    What have I learned recently? Well as it happens I learned something rather interesting recently and was actually trying to …
    Continue reading

  10. Changing configuration settings with sp_configure

    5

    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

Follow

Get every new post delivered to your Inbox.

Join 848 other followers