Tag Archives: microsoft sql server

  1. Updateable CTEs

    Leave a comment

    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

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

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

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

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

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

    Leave a comment

    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

  7. Saving and restoring session options settings

    4

    September 25, 2017 by Kenneth Fisher

    There are a fair number of options settings. ANSI_NULLS, ARITHABORT, QUOTED_IDENTIFIER, etc. Each session has its own set of configurations. …
    Continue reading

  8. Uniquifier is a rather unique word isn’t it?

    8

    September 18, 2017 by Kenneth Fisher

    tl;dr; The uniquifier is used to make a non-unique key in a clustered index unique. Uniquifier is a rather funny …
    Continue reading

  9. Help! My query is too fast!

    1

    September 14, 2017 by Kenneth Fisher

    Said no one ever. Well, maybe. I have had occasions where I needed a brief pause in the middle of …
    Continue reading

  10. There EXISTS a place where SELECT 1/0 doesn’t return an error.

    3

    September 7, 2017 by Kenneth Fisher

    Kendra Little (b/t) reminded me of this fun little trick (with fairly important ramifications) in her latest quiz on logical …
    Continue reading

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

Join 2,134 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013