Category 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. Querying temp tables across a linked server.

    2

    March 14, 2019 by Kenneth Fisher

    And if you are still reading you probably fit into one of the following categories. Not a DBA A relatively …
    Continue reading

  6. Disabling and enabling triggers

    1

    March 6, 2019 by Kenneth Fisher

    I tend to feel that a lot of people who use triggers don’t really understand them. That said, every now …
    Continue reading

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

  8. Bulk insert and an identity column

    1

    December 12, 2018 by Kenneth Fisher

    TL;DR; BULK INSERT doesn’t have an easy way to specify a column list so the columns in the insert file …
    Continue reading

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

  10. SQL Homework – November 2018 – Constraints

    2

    November 5, 2018 by Kenneth Fisher

    You’ve created tables before but how about constraints? Constraints allow a finer level of control over what data is allowed …
    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