Tag Archives: language sql

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

    Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL | Tags: , , ,

  2. DBA Myths: You can’t use an alias in an UPDATE statement.

    4

    September 16, 2013 by Kenneth Fisher

    I’ve found a very common belief among users of T-SQL (both DBAs and Developers) is that you can’t use an …
    Continue reading

    Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: , , , ,

  3. A T-SQL query to get current job activity

    30

    September 5, 2013 by Kenneth Fisher

    I recently had the task of collecting job activity for the purposes of turning it into a report for some …
    Continue reading

    Category: Microsoft SQL Server, SQL Agent Jobs, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL | Tags: , , , , , ,

  4. Lots of ways to UNPIVOT a table

    Leave a comment

    August 21, 2013 by Kenneth Fisher

    I recently read an awesome post on http://www.stackexchange.com questioning how to change columns to rows ie UNPIVOT. One answer demonstrated …
    Continue reading

    Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: , , , , ,

  5. sp_SrvPermissions

    Leave a comment

    August 19, 2013 by Kenneth Fisher

    Last week I posted my stored procedure for database permissions, sp_DBPermissions. A couple of days later I was demonstrating it …
    Continue reading

    Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication | Tags: , , , , ,

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

    Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL | Tags: , , , , ,

  7. How are COALESCE and ISNULL different?

    6

    August 7, 2013 by Kenneth Fisher

    At first glance these two functions seem very similar, and superficially they are. For example COALESCE(fieldname1, fieldname2) and ISNULL(fieldname1, fieldname2) …
    Continue reading

    Category: Microsoft SQL Server, SQLServerPedia Syndication, T-SQL | Tags: , , , , , ,

  8. Database Permissions Queries

    3

    August 5, 2013 by Kenneth Fisher

    Over the last year of blogging my thoughts and queries I’ve discovered something interesting. I posted Where is my Backup? …
    Continue reading

    Category: Dynamic SQL, Microsoft SQL Server, Security, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL | Tags: , , , , , , ,

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

    Category: Dynamic SQL, Microsoft SQL Server, SQLServerPedia Syndication, System Functions and Stored Procedures, T-SQL | Tags: , , , , ,

  10. Scripting a partitioned table or index, a caution.

    14

    July 15, 2013 by Kenneth Fisher

    I was researching a problem with a partitioned table that had somehow become unpartitioned and discovered something rather interesting. First …
    Continue reading

    Category: Microsoft SQL Server, Partitioning, SQLServerPedia Syndication, SSMS, T-SQL | Tags: , , , , , , ,

« Older Entries
Newer Entries »

Follow me via RSS

RSS Feed RSS - Posts

RSS Feed RSS - Comments

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

Join 3,975 other subscribers

Follow me on Twitter

@sqlstudent144

Archives

Categories

Meta

ToadWorld Pro of the Month November 2013