Tag Archives: T-SQL

  1. Using VALUES to construct an in-line table.

    Leave a comment

    May 22, 2019 by Kenneth Fisher

    This has come up a few times recently, I find it rather fascinating and I can never seem to remember …
    Continue reading

  2. How was it done back in the day? T-SQL Tuesday #114

    2

    May 14, 2019 by Kenneth Fisher

    It’s TSQL Tuesday and Matthew McGiffen (b/t) is our host with a subject near and dear to my heart. Puzzles! …
    Continue reading

  3. What version of SQL is SSMS scripting for?

    Leave a comment

    March 25, 2019 by Kenneth Fisher

    Recently (honestly it’s been a few years now) Microsoft split the lifecycle for SSMS out from the general SQL Server …
    Continue reading

  4. Mixed feelings over the new truncation error

    2

    March 20, 2019 by Kenneth Fisher

    As of SQL 2019 CTP2.0 or SQL 2017 CU12 Microsoft has given us a long-awaited addition to the truncation error. …
    Continue reading

  5. Identity in a SELECT

    4

    December 19, 2018 by Kenneth Fisher

    Always be learning right? So when I saw this I had to go HU?! That’s new. What’s going on here? …
    Continue reading

  6. My backup script (where, how, how big, etc.)

    4

    November 26, 2018 by Kenneth Fisher

    A while back I wrote about how to find where your backups are. And I’ve also written about I use …
    Continue reading

  7. Highlighting sp_spaceused

    Leave a comment

    October 15, 2018 by Kenneth Fisher

    I’ve been using sp_spaceused a lot recently so I thought I would bring it up again. Basically it’s a quick …
    Continue reading

  8. Which is faster? IN (list) or IN (SELECT FROM Temp)

    8

    October 11, 2018 by Kenneth Fisher

    If you’ve done much with IN (list) then you’ve realized that it basically translates out to You’ve probably also realized …
    Continue reading

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

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

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

Join 2,503 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013