Tag Archives: best practices

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

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

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

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

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

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

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

  8. Event storming! It’s raining emails!

    3

    March 1, 2017 by Kenneth Fisher

    One of the most common ways to get an event notification is by email. So what happens when you get …
    Continue reading

  9. Queries with optional parameters

    11

    February 27, 2017 by Kenneth Fisher

    These are those queries where you are pulling for, let’s say, a first name, a last name, a state, and/or …
    Continue reading

  10. What is COPY_ONLY?

    2

    January 16, 2017 by Kenneth Fisher

    You’ll frequently hear that you should add the COPY_ONLY clause when taking an ad-hoc full backup to avoid messing up …
    Continue reading

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

Join 1,672 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013