Monthly Archives: June 2013

  1. Using OUTPUT to back up a change

    2

    June 26, 2013 by Kenneth Fisher

    How will you back out if your change doesn’t work?! Always take a backup! There should always be a back …
    Continue reading

  2. Metadata Functions (OBJECT_NAME for example)

    Leave a comment

    June 24, 2013 by Kenneth Fisher

    What is a metadata function? According to BOL a metadata function is one that returns data about the database or …
    Continue reading

  3. Disaster Recovery’s big brother Operational Recovery

    10

    June 20, 2013 by Kenneth Fisher

    I’m going to get slammed for the title by someone but I stand by it. First some definitions. Disaster Recovery …
    Continue reading

  4. ORDER BY the numbers

    17

    June 17, 2013 by Kenneth Fisher

    Have you ever needed to order by a calculated column? You might have written it something like this: Did you …
    Continue reading

  5. Best practice recommendations for writing Dynamic SQL

    13

    June 12, 2013 by Kenneth Fisher

    Note this is not “Best Practices when USING Dynamic SQL”. These are just good habits I’ve come up with over …
    Continue reading

  6. Using the OVER clause

    2

    June 10, 2013 by Kenneth Fisher

    Over the last few years I’ve learned quite a bit about different techniques in SQL Server. This particular one has …
    Continue reading

  7. Easy way to generate a restore script.

    Leave a comment

    June 5, 2013 by Kenneth Fisher

    Easy way to generate a restore script. I was asked today if I had a canned restore script handy. I …
    Continue reading

  8. Pattern searches beyond ‘%string%’.

    4

    June 3, 2013 by Kenneth Fisher

    I was asked today to take a table with a social security column and put all 0s if the column …
    Continue reading

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

Join 1,597 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013