Category Archives: T-SQL

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

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

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

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

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

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

  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,513 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013