Category Archives: Microsoft SQL Server

  1. Letting the business bully you: T-SQL Tuesday #107

    1

    October 9, 2018 by Kenneth Fisher

    Before I start anything I want go give a disclaimer. I absolutely believe that the business should be involved in …
    Continue reading

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

  3. SQL Homework – October 2018 – Time for an upgrade

    Leave a comment

    October 1, 2018 by Kenneth Fisher

    When you created your home lab last September you probably installed a version of SQL 2016. Well, SQL 2017 was …
    Continue reading

  4. Data Types Word Search

    4

    September 26, 2018 by Kenneth Fisher

    Just for fun here is a word search with all of the data types available in SQL Server. Well, two …
    Continue reading

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

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

    8

    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

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

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

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

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

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

Join 2,469 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013