Tag Archives: T-SQL

  1. Dealing with foreign keys when deleting rows.


    October 7, 2021 by Kenneth Fisher

    Deleting rows from a table is a pretty simple task right? Not always. Foreign keys, while providing a ton of …
    Continue reading

  2. Database Sizes


    September 14, 2021 by Kenneth Fisher

    Quick query today. I needed a list of database sizes so came up with this: Nothing exciting, but I figure …
    Continue reading

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


    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

  4. Padding a string in SQL Server


    July 15, 2021 by Kenneth Fisher

    I’ve been working on converting a piece of DB2 code into T-SQL and one of the functions I had to …
    Continue reading



    June 10, 2021 by Kenneth Fisher

    I love CROSS APPLY. I also love OUTER APPLY. What’s the difference though? The same difference as with an INNER …
    Continue reading

  6. Creating a configurable SSMS script


    May 18, 2021 by Kenneth Fisher

    Several times over the last few weeks I’ve gotten a request to create a new work database. The individuals from …
    Continue reading

  7. All jobs that ran during a given time frame.


    May 6, 2021 by Kenneth Fisher

    Short post today. Simple query that will tell you every job that ran between two datetime stamps. Note: this of …
    Continue reading

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

  9. HAL0004 – I don’t feel well Dave


    June 29, 2020 by Kenneth Fisher

    It’s another HAL! Every once in a while (4 times now) I come up with a terrible terrible idea for …
    Continue reading

  10. End an ALTER DATABASE immediately if anyone is in the database.


    June 11, 2020 by Kenneth Fisher

    The development team has told me they’ve shut down the application, there are no more connections and I can go …
    Continue reading

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

Join 3,739 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013