Tag Archives: microsoft sql server

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

  2. When should I add an index?

    7

    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

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

    2

    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

  4. No space queries

    2

    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

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

    Leave a comment

    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

  6. Hiding tables in SSMS Object Explorer

    Leave a comment

    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

  7. Increasing and decreasing the performance level of your Azure SQL Database

    Leave a comment

    March 29, 2017 by Kenneth Fisher

    One of the big benefits of Azure, and in fact any of the cloud offerings I’ve seen, is the ability …
    Continue reading

  8. sp_SrvPermissions & sp_DBPermissions V6.0 Finally!

    1

    March 27, 2017 by Kenneth Fisher

    It’s been almost 3 years since I updated these SPs! I can’t believe so much time has gone by! Well, …
    Continue reading

  9. Creating a list of random numbers

    1

    March 22, 2017 by Kenneth Fisher

    I was working on a blog post this weekend that required a list of random numbers. Now, this isn’t exactly …
    Continue reading

  10. The parts of an object’s name

    Leave a comment

    March 20, 2017 by Kenneth Fisher

    Any object within a database in SQL Server has what is called a four part name. Which rather implies four …
    Continue reading

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

Join 1,627 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013