Monthly Archives: April 2017

  1. Why is a Windows authenticated login more secure than a SQL authenticated one?


    April 26, 2017 by Kenneth Fisher

    I had this question come up at work the other day and while I knew it was true I wasn’t …
    Continue reading

  2. SSMS Tips: Copy Full Path

    Leave a comment

    April 24, 2017 by Kenneth Fisher

    When you right click on a tab you’ll see a number of different options. You can set up new horizontal …
    Continue reading

  3. When should I add an index?


    April 19, 2017 by Kenneth Fisher

    We all know indexes are good and I’m hoping everyone knows you can have too many indexes. That means we …
    Continue reading

  4. What is the “cost” in Cost Threshold for Parallelism?


    April 17, 2017 by Kenneth Fisher

    tl;dr; While at one point the cost of a query was an estimated time to run in seconds, today it’s …
    Continue reading

  5. No space queries


    April 13, 2017 by Kenneth Fisher

    You know, sometimes you get a silly idea in your head and you just HAVE to try it out. The …
    Continue reading

  6. The more things change, the more they stay the same


    April 11, 2017 by Kenneth Fisher

    Koen Verbeeck (b/t) is hosting T-SQL Tuesday this month and our topic is The times they are a-changing. In other …
    Continue reading

  7. How do I change the increment of an identity column?


    April 5, 2017 by Kenneth Fisher

    Wellll .. technically there is no native way to do it. I even went through my notes on identity columns. …
    Continue reading

  8. Hiding tables in SSMS Object Explorer


    April 3, 2017 by Kenneth Fisher

    Extended Properties Sometimes you find out the strangest things about SQL Server. I’ve written about extended properties before but had …
    Continue reading

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

Join 3,616 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013