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

    14

    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

    34

    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

    4

    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

    11

    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

    5

    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

    5

    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”

    1

    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

Follow

Get every new post delivered to your Inbox.

Join 647 other followers