Monthly Archives: October 2017

  1. Haunted SQL: The ghost of Management Studio

    2

    October 30, 2017 by Kenneth Fisher

    Have you ever had a query change performance unexpectedly? Intellisense all of a sudden stops working, or gives inconsistent results? …
    Continue reading

  2. Schema only backup or schema only DB copy

    Leave a comment

    October 25, 2017 by Kenneth Fisher

    Every now and again you have a database where you don’t necessarily need the data. It can easily be re-loaded …
    Continue reading

  3. When is it a good idea to consolidate multiple instances?

    1

    October 23, 2017 by Kenneth Fisher

    In this age of cost-saving after cost-saving, one way you may be looking at saving money is by combining multiple …
    Continue reading

  4. Updateable CTEs

    4

    October 18, 2017 by Kenneth Fisher

    CTEs are cool things. You can essentially create one or more in-line view(s) within your query. One thing that isn’t …
    Continue reading

  5. Permissions required for developing with Temporal Tables

    1

    October 16, 2017 by Kenneth Fisher

    Temporal tables are one of those new (2016+) cool features that recently came across my desk. Basically, a temporal table …
    Continue reading

  6. sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc)

    1

    October 11, 2017 by Kenneth Fisher

    I’ve you’ve done much work with the system views (DMVs for example) then you’ve had to translate an object_id into …
    Continue reading

  7. Small identity columns

    5

    October 9, 2017 by Kenneth Fisher

    We frequently talk about dealing with outgrowing INT identity columns. What we don’t talk about all that often is small …
    Continue reading

  8. The Alpha and the Omega. The BEGIN and the END.

    2

    October 4, 2017 by Kenneth Fisher

    The BEGIN/END block is a fairly standard thing if you’ve ever done any coding, but it never hurts to do …
    Continue reading

  9. Haunted SQL

    Leave a comment

    October 2, 2017 by Kenneth Fisher

    I decided that for Halloween this year it would be fun to tell SQL ghost stories. When I tweeted about …
    Continue reading

  10. SQL Homework – October 2017 – Sample/Test Database(s)

    1

    October 2, 2017 by Kenneth Fisher

    Last month your homework was to set up your own lab. Now it’s time to put a sample database or …
    Continue reading

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

Join 2,151 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013