Tag Archives: code language

  1. Experiment: Does sp_recompile on a table update associated views.

    2

    August 17, 2021 by Kenneth Fisher

    tldr: No. You have to use sp_refreshview. One of the only good things to come out of all of the …
    Continue reading

  2. Long names vs short names (or aliases)

    8

    June 15, 2021 by Kenneth Fisher

    I remember when I was first learning to code there was always the argument of how long a name should …
    Continue reading

  3. SQL Homework – December 2020 – Participate in the Advent of Code.

    Leave a comment

    December 3, 2020 by Kenneth Fisher

    Christmas. Depending on where you live it’s a big deal even if you aren’t Christian. It pervades almost every aspect …
    Continue reading

  4. Generate a random number of children for each parent

    4

    October 3, 2018 by Kenneth Fisher

    I was asked an interesting question the other day. Is it possible to get a different random number of rows …
    Continue reading

  5. Escaping strings

    Leave a comment

    September 24, 2018 by Kenneth Fisher

    No, I’m not talking about that nightmare everyone has where a bunch of strings are chasing you across a loom. …
    Continue reading

  6. Using Table Valued Parameters with sp_executesql

    3

    September 13, 2018 by Kenneth Fisher

    Recently I did a presentation on dynamic SQL. In the presentation I pointed out the similarity of using sp_executesql to …
    Continue reading

  7. SQL Puzzle: Advent of Code

    Leave a comment

    August 29, 2018 by Kenneth Fisher

    A few years back someone started the Advent of code. If you aren’t familiar with it, it’s an advent calendar …
    Continue reading

  8. Moving a table using BCP and native format

    8

    March 21, 2018 by Kenneth Fisher

    You need to move a table from one instance to another with the following requirements: The instances are on separate …
    Continue reading

  9. sp_SrvPermissions & sp_DBPermissions V6.0 Finally!

    7

    March 27, 2017 by Kenneth Fisher

    It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well, …
    Continue reading

  10. Working with “special” names

    4

    October 19, 2015 by Kenneth Fisher

    What do you do when you need to use a special character in a name? Well, I guess I should …
    Continue reading

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

Join 3,576 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013