Tag Archives: system functions

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

  2. Using sp_DBPermissions and sp_SrvPermissions v6.0

    1

    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

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

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

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

  6. Changing configuration settings with sp_configure

    3

    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

  7. What are trace flags?

    Leave a comment

    September 11, 2014 by Kenneth Fisher

    Trace flags are one of those things that I’ve heard about more and more over the last five or six …
    Continue reading

  8. More than sp_help

    1

    August 14, 2014 by Kenneth Fisher

    If you have worked with SQL Server for very long you have probably run across the extremely useful system function …
    Continue reading

  9. What is this default trace you speak of?

    Leave a comment

    June 12, 2014 by Kenneth Fisher

    I frequently see the default trace mentioned in answers to forum questions, blog posts, articles, even training sessions. My knowledge …
    Continue reading

  10. Escaping from a runaway Logon trigger

    1

    May 19, 2014 by Kenneth Fisher

    Most people know that logon triggers can be dangerous if you aren’t careful. And if you didn’t know, well, logon …
    Continue reading

Follow

Get every new post delivered to your Inbox.

Join 680 other followers