Tag Archives: system functions

  1. A better way to find missing indexes

    12

    November 11, 2013 by Kenneth Fisher

    I recently attended SQL Saturday #255 and specifically the performance tuning pre-con put on by Grant Fritchey. It was a …
    Continue reading

  2. Detaching a database

    1

    September 26, 2013 by Kenneth Fisher

    In my general quest to figure out the T-SQL to do common GUI tasks I did some browsing through BOL …
    Continue reading

  3. sp_DBPermissions V2.0

    1

    September 18, 2013 by Kenneth Fisher

    Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The …
    Continue reading

  4. sp_SrvPermissions V2.0

    1

    September 18, 2013 by Kenneth Fisher

    Last month I posted my stored procedures sp_SrvPermissions and sp_DBPermissions. I’m posting V2.0 of each with a few fixes. The …
    Continue reading

  5. sp_DBPermissions

    3

    August 14, 2013 by Kenneth Fisher

    Last week I posted a series of database permissions scripts. I’ve been using them quite a bit over the last …
    Continue reading

  6. Notes on debugging Database Mail problems

    9

    July 29, 2013 by Kenneth Fisher

    I’ve had to debug database mail problems several times over the last year or so. Below is a collection of …
    Continue reading

  7. Generic Dynamic SQL Stored Procedure

    5

    July 22, 2013 by Kenneth Fisher

    Recently I came across a post on http://www.StackOverflow.com that basically asked how to write a generic stored procedure to handle …
    Continue reading

  8. Metadata Functions (OBJECT_NAME for example)

    Leave a comment

    June 24, 2013 by Kenneth Fisher

    What is a metadata function? According to BOL a metadata function is one that returns data about the database or …
    Continue reading

  9. INFORMATION_SCHEMA the un-sung system views

    13

    April 29, 2013 by Kenneth Fisher

    I spend a reasonable amount of time looking through various forums, answering some questions and reading the answers to others. …
    Continue reading

  10. How do I tell the stored procedure name from inside the stored procedure?

    1

    April 24, 2013 by Kenneth Fisher

    I’ve occasionally had the problem of trying to put “smart” logging messages into a process. You know the ones, you’re …
    Continue reading

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

Join 3,739 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013