Monthly Archives: June 2017

  1. SQL Crossword : T-SQL Keywords : June 2017


    June 28, 2017 by Kenneth Fisher

    I did a SQL crossword last month (not my first one either) and it was pretty popular so I asked …
    Continue reading

  2. Temp table quiz


    June 26, 2017 by Kenneth Fisher

    Brent Ozar (b/t) posted a pop quiz on twitter earlier today. Go ahead and give it a shot .. I’ll …
    Continue reading

  3. Dynamically generate the command line DMA statement for each database


    June 21, 2017 by Kenneth Fisher

    If you are upgrading your instance to 2016 (or 2017 soon) then you probably are going to want to run …
    Continue reading

  4. Adding Identity to an existing column


    June 19, 2017 by Kenneth Fisher

    A friend had an interesting problem today. A really big table (multiple millions of rows) and no primary key. He …
    Continue reading

  5. Turning ANSI_PADDING off, and why you shouldn’t


    June 15, 2017 by Kenneth Fisher

    I ran into an interesting error the other day while doing a partition switch. Partition switch failed because : column …
    Continue reading

  6. Buzzword Bingo

    Leave a comment

    June 13, 2017 by Kenneth Fisher

    Grant Fritchey (b/t) is our host for T-SQL Tuesday this month and surprise surprise he’d like to talk about DEVOPS. …
    Continue reading

  7. UDP vs TCP


    June 7, 2017 by Kenneth Fisher

    If you’ve worked much with named instances you’ve probably had to deal with the question “What port is that instance …
    Continue reading

  8. Backup to NUL


    June 5, 2017 by Kenneth Fisher

    Yes, I spelled that correctly. NUL not NULL. NUL is basically a location you can send a backup to. In …
    Continue reading

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

Join 3,753 other subscribers

Follow me on Twitter

ToadWorld Pro of the Month November 2013