Category Archives: T-SQL

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

    1

    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

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

  3. A quick and dirty scan of a list of instances using a dynamic linked server.

    5

    November 12, 2020 by Kenneth Fisher

    Note: This is not exactly a dyanmic linked server. It just gets dropped and recreated in a loop. I recently …
    Continue reading

  4. How do I test if a linked server works using T-SQL?

    4

    October 27, 2020 by Kenneth Fisher

    I get that linked servers are almost as despised as the dreaded cursor or (lord save us) NOLOCK, but they …
    Continue reading

  5. HAL0004 – I don’t feel well Dave

    1

    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

  6. I created a table and SQL created a schema and a user.

    1

    June 22, 2020 by Kenneth Fisher

    Demo first and then I’ll explain what happened. First thing I did was run this script: CreateUsers.bat It’s a quick …
    Continue reading

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

    5

    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

  8. Use session_context to create a “variable” that lasts between batches.

    15

    May 26, 2020 by Kenneth Fisher

    The other day I had a brief conversation with Itzik Ben-Gan (about|twitter) on twitter and I have to tell you …
    Continue reading

  9. Negative (-) is an operator and will affect the order of operations.

    7

    May 18, 2020 by Kenneth Fisher

    An interesting question came to my attention the other day. A strange operation problem in SQL Server: -100/-100*10 = 0 …
    Continue reading

  10. Explain CROSS APPLY like I’m 5.

    5

    May 11, 2020 by Kenneth Fisher

    A good friend of mine (Randolph West (blog|twitter) asked that someone Explain CROSS APPLY like they are 5. So, here’s …
    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