Category Archives: T-SQL

  1. Synonyms, how and why.

    1

    February 15, 2018 by Kenneth Fisher

    Did you know SQL Server has a thing called a synonym? It’s not something you see used very often even …
    Continue reading

  2. What’s dbo?

    2

    January 22, 2018 by Kenneth Fisher

    Don’t you hate it how certain words (well, acronyms in this case) get reused to mean multiple things? dbo seems …
    Continue reading

  3. Fun with sp_rename

    Leave a comment

    January 11, 2018 by Kenneth Fisher

    Currently the only way to rename objects in SQL Server is to use sp_rename. Although that may be changing in …
    Continue reading

  4. SQL Puzzle – Word Scrambler

    2

    November 29, 2017 by Kenneth Fisher

    I’ve been writing crosswords for the last few months and to change things up I thought I would do a …
    Continue reading

  5. Variables in Dynamic SQL

    Leave a comment

    November 16, 2017 by Kenneth Fisher

    I had someone ask me about this the other day. Specifically getting variable data out of a dynamic SQL statement. …
    Continue reading

  6. SQL Homework Nov 2017: Create a view

    3

    November 1, 2017 by Kenneth Fisher

    Views are a highly useful tool for abstracting how you see the data stored in tables. At their simplest, they …
    Continue reading

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

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

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

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

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

Join 2,163 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013