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

  2. Dynamic SQL and the joys of QUOTENAME

    5

    May 11, 2017 by Kenneth Fisher

    I’m a big fan of dynamic SQL. In the past I’ve written a How to, a Best Practices and even …
    Continue reading

  3. Continuous Integration

    Leave a comment

    May 9, 2017 by Kenneth Fisher

    It’s T-SQL Tuesday again! This month we are being hosted by James Anderson (b/t). Thanks James! He has asked us …
    Continue reading

  4. Partitioning on a nullable column

    3

    May 3, 2017 by Kenneth Fisher

    tl;dr; If you are SWITCHing data into a table and the partitioning column is nullable you will need to add …
    Continue reading

  5. Simple Security Report

    2

    May 1, 2017 by Kenneth Fisher

    Quite a while ago I created a couple of little security scripts to help me out with permissions research. Over …
    Continue reading

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

    8

    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

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

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

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

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

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