Tag Archives: Microsoft SQL Server

  1. End an ALTER DATABASE immediately if anyone is in the database.

    5

    June 11, 2020 by Kenneth Fisher

    The development team has told me they’ve shut down the application, there are no more connections and I can go …
    Continue reading

  2. SQL Homework – June 2020 – DML Triggers

    Leave a comment

    June 4, 2020 by Kenneth Fisher

    Triggers. Blech. Triggers are a really really cool feature of SQL Server, that are continuously misused and cause all kinds …
    Continue reading

  3. TSQL Tuesday #127 Invite – Non SQL Tips and tricks

    37

    June 2, 2020 by Kenneth Fisher

    How about for this months TSQL Tuesday let’s do another month of tips and tricks. But just to be a …
    Continue reading

  4. Use session_context to create a “variable” that lasts between batches.

    11

    May 26, 2020 by Kenneth Fisher

    The other day I had a brief conversation with Itzik Ben-Gan (about|twitter) on twitter and I have to tell you …
    Continue reading

  5. Negative (-) is an operator and will affect the order of operations.

    7

    May 18, 2020 by Kenneth Fisher

    An interesting question came to my attention the other day. A strange operation problem in SQL Server: -100/-100*10 = 0 …
    Continue reading

  6. Explain CROSS APPLY like I’m 5.

    5

    May 11, 2020 by Kenneth Fisher

    A good friend of mine (Randolph West (blog|twitter) asked that someone Explain CROSS APPLY like they are 5. So, here’s …
    Continue reading

  7. Could not obtain information about Windows NT group/user

    Leave a comment

    May 6, 2020 by Kenneth Fisher

    This is an interesting error that you’ll occasionally get when accessing an AD/Windows ID. Msg 15404, Level 16, State 11, …
    Continue reading

  8. SQL Homework – May 2020 – Forum Lurking.

    Leave a comment

    May 4, 2020 by Kenneth Fisher

    A few months ago I suggested writing blog post(s) as a great way to learn and document your progress (among …
    Continue reading

  9. Call to action: What do you own?

    2

    April 29, 2020 by Kenneth Fisher

    You restored that database, did you remember to change the owner or is it still you? How about that job …
    Continue reading

  10. What is (local)?

    Leave a comment

    April 27, 2020 by Kenneth Fisher

    When connecting to a SQL Server instance sometimes you’ll see (local), localhost or even just a single period (hard to …
    Continue reading

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

Join 3,516 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013