Category Archives: T-SQL

  1. Using sp_DBPermissions and sp_SrvPermissions v6.0

    Leave a comment

    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

  2. Test your UPDATEs and DELETEs before you run them


    February 18, 2015 by Kenneth Fisher

    This isn’t so much of a best practice, it comes more under the heading of being careful. Let’s say you …
    Continue reading

  3. Tales of a DBA fed up with NOLOCK. Part 1


    February 16, 2015 by Kenneth Fisher

    Nov 12, 2014 Dear Diary, They asked for help again. Every now and again everything slows down and they see …
    Continue reading

  4. Dealing with layered function calls


    February 5, 2015 by Kenneth Fisher

    T-SQL is not the best language in the world for formatting strings. It can be done, but typically you are …
    Continue reading

  5. SQL Judo’s Monthly Challenge – February 2014 – KILL with the DAC

    Leave a comment

    January 26, 2015 by Kenneth Fisher

    Every month SQL Judo (Russ Thomas) (b/t) challenges us to do his Monthly DBA Challenge. I’ve decided it would be …
    Continue reading

  6. Constraint names, Say NO to the default


    January 21, 2015 by Kenneth Fisher

    Have you ever seen a constraint with a name like PK__TableNam__EA185FBF8FF1529D? It’s kind of funny looking right? I mean it …
    Continue reading

  7. Except and Intersect


    January 19, 2015 by Kenneth Fisher

    EXCEPT and INTERSECT are two uncommon commands. Not that they do anything odd but they aren’t exactly well known in …
    Continue reading

  8. Pagination in SQL Server


    January 15, 2015 by Kenneth Fisher

    It amazes me how much easier certain tasks have gotten in SQL Server. I was watching the Nov 2014 SQL …
    Continue reading

  9. Finding the reason for the error “Subquery returned more than 1 value”


    January 7, 2015 by Kenneth Fisher

    First this type of error is because a subquery returned more than one row when it wasn’t allowed to. In …
    Continue reading

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


Get every new post delivered to your Inbox.

Join 647 other followers