Tag Archives: microsoft sql server

  1. Adding Identity to an existing column

    1

    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

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

    3

    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

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

  4. UDP vs TCP

    3

    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

  5. Backup to NUL

    6

    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

  6. SQL Crossword

    6

    May 31, 2017 by Kenneth Fisher

    I thought I’d do another crossword. Enjoy! If you need any help with it feel free to let me know …
    Continue reading

  7. Running multiple queries at the same time.

    8

    May 24, 2017 by Kenneth Fisher

    I read an interesting question today. Someone wanted to be able to run the same stored procedure multiple times, at …
    Continue reading

  8. What’s in a partition?

    Leave a comment

    May 22, 2017 by Kenneth Fisher

    In my last post on partitioning I used the $Partition command in passing. I’ve been thinking it deserves a bit …
    Continue reading

  9. T-SQL FizzBuzz

    15

    May 17, 2017 by Kenneth Fisher

    I was looking around for something to write about this evening and came across one of Russ Thomas’ (b/t) old …
    Continue reading

  10. Why shouldn’t I shrink my database log file?

    1

    May 15, 2017 by Kenneth Fisher

    TL;DR: It’s pretty pointless and can cause performance issues. Let’s start by asking why you might want to shrink your …
    Continue reading

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

Join 1,653 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013