Category Archives: SQLServerPedia Syndication

  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. SQL Puzzle – Prime Numbers

    6

    September 27, 2017 by Kenneth Fisher

    My goal here is to have something fun (and hopefully educational/thinky) (and yes, I did just make up the word …
    Continue reading

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

  9. Do what I say, not what I do

    Leave a comment

    September 20, 2017 by Kenneth Fisher

    I told you not to use NOLOCK even though I use it sometimes. I told you not to shrink databases, …
    Continue reading

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

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