Tag Archives: language sql

  1. What is a CTE

    3

    April 6, 2015 by Kenneth Fisher

    CTEs (Common Table Expressions) are one of the most interesting and useful tools added to T-SQL in the last decade. …
    Continue reading

  2. Clean out all bad characters from a string.

    10

    March 25, 2015 by Kenneth Fisher

    I have a customer who is having a problem with a load. He is getting a fair number of bad …
    Continue reading

  3. Why not NOLOCK?

    10

    March 18, 2015 by Kenneth Fisher

    Most senior DBAs I’ve met shudder when they hear NOLOCK. Ever wonder why? For the same reason they shudder at …
    Continue reading

  4. There are #temp tables and then there are ##temp tables.

    1

    March 16, 2015 by Kenneth Fisher

    Temporary tables are a common enough thing in T-SQL that most of us have probably used them on a fairly …
    Continue reading

  5. Who’s using that database?

    1

    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

  6. I want to blog but …

    2

    March 4, 2015 by Kenneth Fisher

    I don’t know how to get started. Pretty simple. There are a number of free blogging sites out there. Personally …
    Continue reading

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

  8. Test your UPDATEs and DELETEs before you run them

    15

    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

  9. Dealing with layered function calls

    5

    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

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

    1

    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

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

Join 3,746 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013