Tag Archives: best practices

  1. sys.objects VS helper functions (OBJECT_ID, OBJECT_NAME, etc)

    1

    October 11, 2017 by Kenneth Fisher

    I’ve you’ve done much work with the system views (DMVs for example) then you’ve had to translate an object_id into …
    Continue reading

  2. Small identity columns

    5

    October 9, 2017 by Kenneth Fisher

    We frequently talk about dealing with outgrowing INT identity columns. What we don’t talk about all that often is small …
    Continue reading

  3. Do what I say, not what I do

    Leave a comment

    September 20, 2017 by Kenneth Fisher

    I told you not to use NOLOCK even though I use it sometimes. I told you not to shrink databases, …
    Continue reading

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

    4

    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

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

    2

    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

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

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

  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. Limits vs Goals

    1

    March 14, 2017 by Kenneth Fisher

    It’s that time again. Kennie Nybo Pontoppidan (b/t) is the host this month and has a fun topic for us. …
    Continue reading

  10. Using GROUP BY instead of DISTINCT

    6

    March 6, 2017 by Kenneth Fisher

    Recently, Aaron Bertrand (b/t) posted Performance Surprises and Assumptions : GROUP BY vs. DISTINCT. In it he says he prefers …
    Continue reading

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

Join 2,134 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013