Monthly Archives: July 2014

  1. The clustered index columns are in all of the non clustered indexes.

    13

    July 30, 2014 by Kenneth Fisher

    Did you know that whatever columns you pick as your clustered index will be included in any non clustered indexes …
    Continue reading

  2. What is ANSI_NULLS and why will I be glad when it finally goes away?

    12

    July 28, 2014 by Kenneth Fisher

    Recently I wrote about what it means that a value is NULL. Right at the beginning I mentioned ANSI_NULLS and …
    Continue reading

  3. Why am I getting a primary/unique key violation?

    3

    July 23, 2014 by Kenneth Fisher

    This may seem like a question with a simple answer but there is a bit more to it than you …
    Continue reading

  4. Add them to ALL the roles!

    3

    July 21, 2014 by Kenneth Fisher

    I seem to get a lot of permissions questions these days and one of the more frequent ones goes along …
    Continue reading

  5. Yes, Virginia, you can have too much white space.

    21

    July 16, 2014 by Kenneth Fisher

    When I was in college and taking programming classes (back in the days when “a T-Rex ate my 5.25 inch …
    Continue reading

  6. What does it mean that a value is NULL?

    11

    July 14, 2014 by Kenneth Fisher

    Let’s start by assuming that ANSI_NULLS are ON. If you aren’t sure what ANSI_NULLS are exactly, don’t worry, I’ll be …
    Continue reading

  7. db_ddladmin and the SSMS table designer

    Leave a comment

    July 10, 2014 by Kenneth Fisher

    If you want to grant a user the ability to create/alter/delete any table, SP, function etc in a database you …
    Continue reading

  8. T-SQL Tuesday #56: Assumptions

    6

    July 8, 2014 by Kenneth Fisher

    I assume that since it’s the second Tuesday of the month that it’s time for T-SQL Tuesday. And you can …
    Continue reading

  9. Argenis and the unicorn hoodie

    1

    July 2, 2014 by Kenneth Fisher

    Early yesterday Kirsten Benzel(b/t) announced something very exciting, at least exciting to me. Argenis Fernandez(b/t) has agreed to wear a …
    Continue reading

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

Join 1,597 other followers

Follow me on Twitter

ToadWorld Pro of the Month November 2013