1. You can’t DELETE TOP (x) with an ORDER BY

    5

    September 19, 2018 by Kenneth Fisher

    Did you know you can’t do this? Msg 156, Level 15, State 1, Line 8 Incorrect syntax near the keyword …
    Continue reading

  2. How do I grant permissions to view users and their permissions?

    1

    September 17, 2018 by Kenneth Fisher

    tl;dr; VIEW DEFINITION Every now and again you’ll have a user that needs to be able to see what permissions …
    Continue reading

  3. Using Table Valued Parameters with sp_executesql

    3

    September 13, 2018 by Kenneth Fisher

    Recently I did a presentation on dynamic SQL. In the presentation I pointed out the similarity of using sp_executesql to …
    Continue reading

  4. What happens in a trigger stays in the transaction: T-SQL Tuesday #106

    Leave a comment

    September 11, 2018 by Kenneth Fisher

    Anything that happens in a trigger happens within the same transaction of the command that called it. Part of me …
    Continue reading

  5. I/O vs Logical I/O

    Leave a comment

    September 5, 2018 by Kenneth Fisher

    tl;dr; While the difference is very important 90% of the time you won’t care and should just add the two …
    Continue reading

  6. SQL Homework – September 2018 – Backup and Restore continued.

    Leave a comment

    September 3, 2018 by Kenneth Fisher

    In the very first SQL Homework post you were asked to take a backup. In fact it asked you to …
    Continue reading

  7. SQL Puzzle: Advent of Code

    Leave a comment

    August 29, 2018 by Kenneth Fisher

    A few years back someone started the Advent of code. If you aren’t familiar with it, it’s an advent calendar …
    Continue reading

  8. Copying formatted text out of a grid column.

    3

    August 27, 2018 by Kenneth Fisher

    I was reading a post today by Bert Wagner (b/t). Displaying Long Variable Values in SQL Server By the way, …
    Continue reading

  9. #SQLCareer 3/4 August 6th 2018

    Leave a comment

    August 22, 2018 by Kenneth Fisher

    Last month Steve Jones (b/t) suggested that it might be helpful if those of us that work in the IT/database …
    Continue reading

  10. Nada to Speaker: Demystifying and Diminishing Dynamic SQL Difficulties

    3

    August 20, 2018 by Kenneth Fisher

    Last Thursday I spoke at NTSSUG (North Texas SQL Server User Group). This is my local group (only 1.5 hours …
    Continue reading

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

Join 2,452 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013