Tag Archives: code language

  1. Adding, altering or removing multiple columns from a table

    2

    April 16, 2015 by Kenneth Fisher

    I was recently asked to do some fairly heavy modifications to a table. It involved adding 6 new columns, removing …
    Continue reading

  2. What is a CTE

    1

    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

  3. Why not NOLOCK?

    5

    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.

    Leave a comment

    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?

    Leave a comment

    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. SQL Judo’s Monthly Challenge – March 2014 – Powershell something

    1

    March 2, 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

  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

    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

  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

Follow

Get every new post delivered to your Inbox.

Join 798 other followers