Tag Archives: best practices

  1. Restrict the usage of a SQL Server Authenticated Application Id

    1

    December 6, 2017 by Kenneth Fisher

    SQL Server login ids may not be the most secure thing in the world but they are likely to be …
    Continue reading

  2. Closing all of the connections to a database

    3

    November 27, 2017 by Kenneth Fisher

    Doing a database restore may not be the most common task a database professional will ever do, but it’s a …
    Continue reading

  3. Why shouldn’t I shrink my database data file?

    2

    November 20, 2017 by Kenneth Fisher

    A while back I did a post about why you shouldn’t shrink your data file. This one is going to …
    Continue reading

  4. When is it a good idea to consolidate multiple instances?

    1

    October 23, 2017 by Kenneth Fisher

    In this age of cost-saving after cost-saving, one way you may be looking at saving money is by combining multiple …
    Continue reading

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

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

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

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

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

    3

    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

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

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

Join 2,151 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013